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 Act...
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