Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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:

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






 

 

6 Replies

  • Anonymous , Try like

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      amitchandak I already tried: 


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

       

  • Anonymous's avatar
    Anonymous
    Not 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

    • Anonymous's avatar
      Anonymous
      Not 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]) 

      • Anonymous's avatar
        Anonymous
        Not 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