Forum Discussion
Creating relationships
I am trying to show start of month of my revenue and compare it to previous revenue in my KPI. Except My I am only returning the same values for revenue current start of month and revenue previous mo...
Hi Anonymous ,
As far as I know, you need to create a continuous calendar table and then create a relationship between it and your data table for using time intelligence function.
Then you can try PREVIOUSMONTH() function to create a measure to calculate the previous month data.
You can also refer to LeandroDeodato's link to learn more about time intelligence function in DAX.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.