CALCULATE is the most powerful function in DAX, as it allows you to change the filter context under which its expression is evaluated to your hearts content. But with big (…) Read more
Posts Tagged ‘DAX’
Memory efficient clustered running total in Power BI
Today I want to share a scenario where a running total calculation in the query editor saved a model that run out of memory when done with DAX: Problem The (…) Read more
DAX evaluation context indicator with syntax highlighting
This is a post about a feature request, that definitely would make my life easier (and I guess others’ too): Evaluation context and its transition is one of the hardest (…) Read more
Right Aligning Text in Power BI: Format Improvements for Easy Profit&Loss Reports
Edit 14-Dec-2017: Now that we can right-align text measures in PowerBI, a SWITCH-measure like here: http://www.thebiccountant.com/2017/04/24/kpis-in-easy-profit-and-loss-for-powerbi/#comment-719 is the best alternative in my eyes. No need to read on 🙂 As (…) Read more
KPIs in Easy Profit and Loss for PowerBI
Welcome to the last part of my Easy Profit & Loss series where I will cover KPIs in rows & columns: 1) KPIs in columns Show all your figures as (…) Read more
Guide for switching Signs in Power BI and Power Pivot (bypassing Unary Operators in DAX)
In finance & accounting, you very rarely report the figures with the signs of their source systems, but switch (certain) signs according to different needs. Instead of using unary operators (…) Read more