Reg: Compare Actual value with two different month based on selection in slicer

[adityapv]

Hi Everyone,please help me with this scenario.

1.I need to compare actual value based on the selection of two different months from slicers same like table in attached image.

2.I have taken same date for the months of two slicers.

3.how to achieve with out disturbance one each other slicer.

please find the attached image.

[v-yalanwu-msft · Accepted solution]

Hi , @adityapv ;

According to you description，you could enter a table as slicer to achieve with out disturbance, then create a measure, as follows:

1.Create a new table as slicer2

Slicer2 = SUMMARIZE('Table',[Month])

2.Create a measure to calculate Actual For month2

Actual For month2 = CALCULATE(SUM([Actual For month1]),FILTER(ALLEXCEPT('Table','Table'[Organization name]),[Month]=MAX('Slicer2'[Month])))

The final output is shown below:

     

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@adityapv , I discussed a similar topic in my video, refer if that can help

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg