Viraj RathnayakaforVirajR's Blogvirajr.hashnode.net·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...Discussdax
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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...Discussdax
Stephen David-WilliamsforStephen's blogspiritman7.hashnode.net·Mar 9, 2023Using Power Query to clean data in Power BIAlthough most of my data cleaning is conducted with Spark in Databricks, there are scenarios where my data doesn't need to undergo heavy transformations. If I can get my data to the output I need in just a few short steps, why not do that? In this bl...Discuss·49 readsPowerBI
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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...Discussdax
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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...Discussdax
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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...Discussdax
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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...Discussdax
Viraj RathnayakaforVirajR's Blogvirajr.hashnode.net·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...DiscussPowerBI
Viraj RathnayakaforVirajR's Blogvirajr.hashnode.net·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...Discussdax
Stephen David-WilliamsforStephen's blogspiritman7.hashnode.net·Mar 9, 2023Using Power Query to clean data in Power BIAlthough most of my data cleaning is conducted with Spark in Databricks, there are scenarios where my data doesn't need to undergo heavy transformations. If I can get my data to the output I need in just a few short steps, why not do that? In this bl...Discuss·49 readsPowerBI
