topic Re: Need Help with a DAX Measure in DAX Commands and Tips

Need Help with a DAX Measure

Anonymous — Mon, 15 Nov 2021 07:02:36 GMT

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

Re: Need Help with a DAX Measure

amitchandak — Mon, 15 Nov 2021 08:11:18 GMT

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

Re: Need Help with a DAX Measure

v-luwang-msft — Thu, 25 Nov 2021 03:01:49 GMT

Hi Anonymous ,

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

Best Regards

Lucien