1 of 1 people found this helpful
a workbook may be nice if it's something that you can do
In the meantime i have another possible solution:
What if you used
if Max(Datepart('month',Date) > 12 then [Do the thing you're trying to do]
else [do the other thing]
You may have to change the 12 to your custom fiscal year. But what that is saying is, "If the most recent date is December- then i have full data". Now you may have to tweak this to a different 'Date Level' if need be (could even use quarter)
And this solution may not be what you need, just wanted to add a thought
Figured it out and I'm not going to tell how much time it took me...
DATEPART('month',max([Ddat]))=6 then.... Else.... End.
Since our FY starts in July - if the max month is 6 (June) then we've got a full year and if not then we don't.
Thanks and have a great weekend!
Your solution is very similar to mine. Glad you figured it out!