Forum Discussion
Last year Formula is almost correct...
FY 19 & 20 on my last year volume are incorrect, however FY21 down is correct. What is happening here??
This is my formula for LY VOlume:
3 Replies
lennyt99 DAX TI functions don't have a clue about fiscal years and thus, it is typically a really bad idea to use DAX TI functions when performing calculations involving fiscal dates instead of standard Gregorian calendar dates. You are going to get weird results.
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008Greg_Deckler I'm still confused... I have a fiscal calender converted (i made it in excel) and it's marked as my date table and working). It's just those two values that are off.. can you please help me write something to fix it? maybe
VAR __Date = MAX('Fiscal Year Conversion'[Calendar Date])VAR __LYDate = EOMONTH(__Date,-12)VAR __LYEndDate = DATE(YEAR(__LYDate),MONTH(__LYDate),DAY(__Date))VAR __LYDateStart = EOMONTH(__LYDate,-12)VAR __LYStartDate = DATE(YEAR(__LYDateStart),MONTH(__LYDateStart),DAY(__Date))RETURNSUMX(FILTER(ALLGreg_Deckler what could I wrtie to fix it?
