Custom Fiscal Year error

arp2 - At a guess, I would say you're not removing the filter context from your Fiscal Year Calendar and then re-adding the new context you wish to calculate. In order to do this you can use REMOVEFILTERS( Fiscal Year Calendar ) 

Here's an example:

VAR prev_week_start = SELECTEDVALUE( DateTable[Previous Week Start] )
VAR prev_week_end = SELECTEDVALUE( DateTable[Previous Week End] )

RETURN
CALCULATE( [Measure], REMOVEFILTERS( DateTable ), Table[Date] >= prev_week_start && Table[Date] <= prev_week_end )

However this is just a guess, because you've not provided your DAX that's returning 0 so.......

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!

Hi arp2,

Thank you for reaching out to the Microsoft fabric community forum. Also thanks to mark_endicott, for his insights on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it. Used line chart.

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.