Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need Help with a DAX Measure

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 

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    Hi Anonymous ,

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

     

    Best Regards

    Lucien