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.
Hi,
I tried all other solutions online and I cant seem to wrap my head around solving this.
I hope I didn't mess up the sample example below.
Also keep in mind that:
1: Our Fiscal year begins Jun 1.
2: there are multiple dates for the same day every day of the year.
3. My data spans 3 years
I would like to simply list the prior FY values if it is available so that I can do a final difference calculation from the prior FY values to the Current FY values. I have tried things like PREVIOUSYEAR, but i think that is thrown off by the multiple same dates and subcatagories?
How can this be solved?
Thank you,
Mike
Nobody? 😞
Hi @mikelee1701 ,
Can you provided a sample of your pbix with the data above, so I can understand how your model is strcutured?
Did I help you today? Please accept my solution and hit the Kudos button.
@davehus ,
Thanks, but I have company sensitive items, but the above table can all be in one table (date, type, service, workflow, type, Value). I do have a calendar table that contains the Fiscal years that I spoke about that is linked to that table above. That's about it. All the work is mostly in one table.
User | Count |
---|---|
86 | |
83 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |