Forum Discussion
Compare same value in different periods
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
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])
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
Anonymous Thanks. I know this is not the right measure and you are right that I need to work with filter. But how can I integrated the filter of a relative date in my measure. Now I just use the sidebar Filter. I have two bars. One should be filtert the other not.