How to get prior Fiscal year values if there are multiple same dates and sub categories

[mikelee1701]

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

[mikelee1701]

Nobody?  😞

[davehus]

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.

[mikelee1701]

@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.