Compare same value in different periods

[Anonymous]

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:

Spare Parts Last month = CALCULATE([Spare Order Backlog False],

PARALLELPERIOD(Dates[Date], -1, MONTH))

This does not show the desired dates in the table - just last month

[Anonymous]

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]

@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]) 

[Anonymous]

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]

@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.  

[amitchandak]

@Anonymous , Try like

Spare Parts Last month = CALCULATE([Spare Order Backlog False],
dateadd(Dates[Date], -1, MONTH))

[Anonymous]

@amitchandak I already tried: 

The solution could be using a visual filter with dates but in the measure?