Forum Discussion
Solved
Previous Fiscal Year value not calculated correctly
I am trying to get premium value for previous fiscal year and consequently Growth over fiscal year. However, none of the below DAX query giving me correct result. ---------------------DAX to get Pr...
Hi shailendransit,
I think the time intelligence function may not suitable to work with fiscal date.
Perhaps you can try to use date function to get the current date based on current fiscal date, then you can use this as condition to calculate with previous range records.Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
Hi shailendransit,
I think the time intelligence function may not suitable to work with fiscal date.
Perhaps you can try to use date function to get the current date based on current fiscal date, then you can use this as condition to calculate with previous range records.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng