Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.