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: Spare Parts Last month = CALCULATE([Sp...
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.