Viraj Rathnayakavirajr.hashnode.dev·Jul 28, 2023How to get sales value for the previous 12 months from the latest available date in Power BI.In this post, we are going to find out how to, Getting previous 12 months' sales from today. Getting previous 12 months' sales from the latest available date. Getting the previous 12 months (or any number of months) is a pretty common requirement...DiscussPower BI
Viraj Rathnayakavirajr.hashnode.dev·Jul 16, 2023I've earned Microsoft certification for Power BI Data Analyst Associate (PL-300) & here's how I did it.🎉Spoiler Alert! It wasn't easy....😅 After 5 years I first started working with Power BI, I finally managed to earn my first Microsoft certification for Power BI Data Analyst Associate for one year (2023-2024) after passing the PL-300 exam by the narr...DiscussPowerBI
Viraj Rathnayakavirajr.hashnode.dev·Jul 9, 2023How to do COUNTIF in Power BIThis is the 2nd post of the Excel-to-Power BI series and in this post, we gonna discuss how to count with condition or perform a COUNTIF( ) in Power BI. Is there a COUNTIF in Power BI No. COUNTIF is not directly available to use in Power BI. However ...DiscussPowerBI
Viraj Rathnayakavirajr.hashnode.dev·Jun 6, 2023How to do SUMIF( ) in Power BIIf you are transitioning to Power BI from Excel, you may have used the SUMIF function to calculate the sum of a range based on a condition. You may have been confused to find out that in Power BI there is no single function to get SUMIF. Is there a S...DiscussPowerBI
Rajanand Ilangovanblog.rajanand.org·Apr 16, 2023Mastering DAX Context: Understanding Row, Filter, and Evaluation ContextWhen working with DAX in Power BI, there are three critical contexts that you need to understand: Row context Filter context Evaluation context These contexts determine how DAX expressions are evaluated, and understanding them is crucial to crea...Discuss·257 readsdax
Rajanand Ilangovanblog.rajanand.org·Apr 9, 2023Understanding Calculated Columns and Measures in DAXWhen working with data in Power BI or other analytical tools, creating calculations on the fly can be essential to understanding and making sense of the data. This is where calculated columns and measures come into play. These two features in DAX can...Discuss·53 readsdax
Rajanand Ilangovanblog.rajanand.org·Apr 8, 2023Mastering DAX BasicsIntroduction Data Analysis Expressions (DAX) is a powerful formula language used in Power BI, Excel, and other business intelligence tools. DAX enables you to create complex calculations and queries to analyze large amounts of data quickly and effici...Discuss·78 readsdax
Rajanand Ilangovanblog.rajanand.org·Apr 6, 2023Data Modeling in DAXIntroduction Data modeling is a crucial component in DAX (Data Analysis Expressions), which is the formula language used in Power BI, Excel, and other Microsoft data analysis tools. A well-designed data model enables analysts to analyze and visualize...Discuss·83 readsdax
Viraj Rathnayakavirajr.hashnode.dev·Apr 5, 2023Compare the current day's data with the previous day's data in Power BI.In this blog post, Let's discuss how to use Power BI DAX to compare the current day's data with the previous day's data in the current context. We'll do it by using the stock price of 5 top US companies and then move on to, Compare the current day's...Discuss·27 readsPowerBI
Viraj Rathnayakavirajr.hashnode.dev·Apr 1, 2023Compare the current month's data with the previous month's data in Power BI.In this blog post, Let's discuss how to use Power BI DAX to compare data from the last month with data from this month. We'll start by using the selling price of 5 Products and then move on to, compare this month's prices with last month's prices of...Discuss·34 readsdax
