Forum Discussion
Rolling Returns Issue. please help
Hi All, I want to calculate QTD, MTD, YTD and 1Yr,2Yr and 5 Yr rolling returns based on Category P and I for the attached dataset . when i tried using the quick measure, it fails and gives a error ...
ak77 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, 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