Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Hi @Anonymous ,
I not see the PY in the table ,could you share your expected output?
Best Regards
Lucien
@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
User | Count |
---|---|
15 | |
13 | |
12 | |
10 | |
10 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
10 |