Forum Discussion
Compare same value in different periods
Hi Power BI Community!
I want to show this data in a bar chart:
Date Period: 29.07.2021
Date Period: 29.06.2021
I tried with this measure:
This does not show the desired dates in the table - just last month
6 Replies
- amitchandak
Super User
Anonymous , Try like
Spare Parts Last month = CALCULATE([Spare Order Backlog False],
dateadd(Dates[Date], -1, MONTH))- AnonymousNot applicable
amitchandak I already tried:
The solution could be using a visual filter with dates but in the measure?
- AnonymousNot applicable
Hi Anonymous ,
Which one is the desired out put? And why the value for June is different in these two tables?
Can you provide some sample data and the measure you are using to us?
Best Regards,
Jay
- AnonymousNot applicable
Anonymous Thanks for the reply.
To show the different process of the data in June is the point!
The first table has the data filter on 29.07.21
The second table has the data filter on 29.06.21.
I want to show the change in data (June on 29.07 = 6,53 %, June on 29.06 = 5,39 %
The measure is simple like that = Divide([Count false],[Count All])- AnonymousNot applicable
Hi Anonymous ,
Your current measure is to calculate the last month value.
But if you want to calculate the value from different periods, you will need to filter the table before the calculation.
Best Regards,
Jay