DAX problem when trying to sum quantity in different contexts Understanding DAX Summing Quantities in Different Contexts When working with DAX Data Analysis Expressions users often encounter complex scenarios where calcula 2 min read 25-09-2024 46
A function like ALLEXCEPT but to ignore filters coming from measures A Function Similar to ALLEXCEPT that Ignores Filters from Measures When working with DAX in Power BI or SQL Server Analysis Services SSAS you may often encounte 2 min read 19-09-2024 33
Calculate first date similar to sql window function in DAX Calculating the First Date Similar to SQL Window Functions in DAX If you re transitioning from SQL to DAX Data Analysis Expressions and find yourself needing to 2 min read 19-09-2024 37
DAX calculate relatively last month, quarter and year Mastering Relative Time Calculations in DAX Last Month Quarter and Year Power BIs DAX language is a powerful tool for data analysis One common need is to compar 2 min read 13-09-2024 37
DAX statement - "to RETURN, or not to RETURN" The DAX RETURN Statement When to Use It and When Not To DAX Data Analysis Expressions is a powerful language used within Power BI and other tools to manipulate 2 min read 02-09-2024 54
DAX measure to calculate merchants with first transaction in current year markdown Calculating New Active Merchants with First Transactions in the Current Year Using DAX If you re working with Power BI and need to analyze merchant act 3 min read 31-08-2024 35
Groupby and sum the max in DAX Mastering Group By and Max in DAX A Comprehensive Guide Power BI is a powerful tool for data visualization but sometimes you need to perform complex calculation 2 min read 30-08-2024 50
PowerBI Data Export: Large Matrix Table Power BI Data Export Overcoming the 10 K Row Limit for Large Matrix Tables Power BIs matrix visual is a powerful tool for visualizing and analyzing large datase 2 min read 28-08-2024 39
DAX studio not showing as external tool in Power BI desktop DAX Studio and Tabular Editor not showing as external tools in Power BI Desktop This article provides a comprehensive guide to troubleshooting the issue of DAX 2 min read 27-08-2024 40
Using Multiple EVALUATE statements in DAX Studio Using Multiple EVALUATE Statements in DAX Studio DAX Studio is a powerful tool for working with DAX queries One of its features is the ability to run multiple E 2 min read 27-08-2024 44