Need Help with a DAX Measure

[Anonymous]

Hi Team,

I have a Table with 2 Columns Period and Value as shown in the below image.

I need to create 2 Power BI measures for Comparison and 2 Slicers from Period Column Base and Actual.

If I select CM in Actual and PY in Base, the comparison should be done between 112 and 116, the calculations should change based on the values that I select in Base and Actual Slicers.

Thanks in Advance.

Kuber Kumar

@Kuberkkk 

[v-luwang-msft]

Hi @Anonymous ,

I not see the PY  in the table ,could you share your expected output?

Best Regards

Lucien

[amitchandak]

@Anonymous , Create two table using distinct values of period. Keep them independent and use there values as filter

P1 = calculate(Sum(Table[Value]), Filter(Table, Table[Period] in allselected(period1[period]) ))

P2 = calculate(Sum(Table[Value]), Filter(Table, Table[Period] in allselected(period2[period]) ))

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