Calculation Groups to the Rescue!
o set the stage, I need you to travel back in time with me a bit. The year was 2019, and none of us had ever heard of COVID-19…those were simpler times.
Category: The CALCULATE Function
Using DAX Magic For Variable Forecasting
I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection.
DAX – The Great Precedence Project (Filter Rules for DAX)
“Wait a minute. There might be legal precedent. Of course. Land snatching. Let’s see, land, la-land…see snatch. snatch…snatch…ah! Haley vs. United states. Haley 7, United States nothing. You see, it can be done!
Power BI and Power Pivot DAX: CALCULATE is a supercharged SUMIF
“No [doubt] she’ll freak. I’m just contemplating the =IF()’s…” -Marcellus Wallace, obvious master of the spreadsheet arts CALCULATE is a supercharged SUMIF I can’t believe I didn’t say this last […]