Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created two measure current year sales and previous year Sales and I have year Slicer
I have created table Customer wise current year and previous year sales
What I want is
When I select year then current year column name should show as selected year and previous year as (year - 1) eg year = 2023 then previous year = 2022
But If I dont select any year then It should give me only one column of overall sales customer wise and also If I select start year ie First Year then There wont be any Previous Year Data then should get only one column of current year
??
Please help me in this since stuck since 2 days and there is presentation in 10 Days ....
Solved! Go to Solution.
Hi,
its a bit tricky, however you can achieve that with few measures.
First, I created a sample table like below:
Then created below measures:
Now, for your column header, create 3 more measures:
when 2023 selected:
If this resolves your problem, then please mark it as Solution, Thanks!
Hi,
its a bit tricky, however you can achieve that with few measures.
First, I created a sample table like below:
Then created below measures:
Now, for your column header, create 3 more measures:
when 2023 selected:
If this resolves your problem, then please mark it as Solution, Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |