Forum Discussion
Dynamic Previous Period Comparison
I'm also experiencing a similar problem. I would like to display the data according to time X and its corresponding Previous period.
For example by the last 3 days, and accordingly the three days preceding them.
Suppose I show the scale between the 10th and the 13th of the month, so the previous period will be between 7 and 10.
The solution to be dynamic. That you can determine the amount of days / months / period on which I want to calculate, and accordingly will be calculated the period preceding it
I am running into the same problem and found this post really helpful:
http://radacad.com/previous-dynamic-period-dax-calculation
You can create dynamic previous period measures using DAX.
However, I still think Power BI should provide this feature in the date slicer. If I have lots of measures that I want to allow my users to perfome this kind of comparisions, then I would have to create lots of previous period measures. That's too much work!
Here is the idea that you can vote:
