Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Need Help with a DAX Measure

Hi Team,

 

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

 

KadaKuberKumar_0-1636959291187.png

 

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 2
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

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

 

Best Regards

Lucien

amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.