Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Visualize Rolling 12 Months

Hi Everyone,    I've spent about two days researching how to accomplish this, reading articles both on the PBI forum and also external articles. I've attempted to solve this myself using some DAX o...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler  Thanks for your response, I actually referenced that before I posted. 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous Great, sample/example data as text would be great!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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