Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |