Forum Discussion
Visualize Rolling 12 Months
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Greg_Deckler Thanks for your response, I actually referenced that before I posted.
Anonymous Great, sample/example data as text would be great!
Hi Greg_Deckler - thank you! Here's the .pbix file and you'll also find the dataset in an excel file. I'm very new at DAX and I've been learning at lot, thanks to some articles like yours. :).
Really need to figure out how to get this visual to appear in a rolling way, like I have it in the example above.
I've been doing a bit more research on the forums and online on how to get this configured and calculated correctly, but still running into some issues. For example, the % Churn calculation isn't calculating correctly overall and MoM.
Churn is calculated as follows = Total#ofChurn/Avg.MonthlyHC. I believe I might be missing some pieces in my dax code.
Could you take a look and let me know please? Please let me know if you have issues accessing the files.
Thanks Much