DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)
DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.
DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.
Based on what I’ve learned from Zoe, and what I’ve read to fill in the gaps, I think the two big differentiators are “how much statistical rigor do you require” and “how many different variations of the question do you need to ask?”
The autoexist logic magically removes combinations that don’t exist, but only for columns in the same table. Also, Cross Table Filtering…
Forecasting is when we anticipate the behavior of lots of people on long timelines. Predictive Analytics anticipate the behavior of One person…
Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about.