Forum Discussion
DAX HELP
I want to calculate current Fiscal Year End Date (April - March) Suppose for Today, Fiscal year end date should be 31-03-2021
Anonymous
Hi, try with this calculated column:
CurrentEndFiscalYear = IF ( MONTH ( 'Table'[Date] ) <= 3; DATE ( YEAR ( 'Table'[Date] ); 03; 31 ); DATE ( YEAR ( 'Table'[Date] ) + 1; 03; 31 ) )Regards
Victor
That's really not a lot to go on. 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/434008
Not a pro in dax. Can you please help on this. I tried formulas , but getting wrong data.
I am not clear on what you want. Are you saying that you want to have a "total ytd" measure that runs from April 1st, 2019 to March 31st, 2020 for example? If so, perhaps something like:
Measure = VAR __Date = MAX([Date]) VAR __Year = YEAR(__Date) VAR __FiscalEndMonth = 3 VAR __FiscalEndDay = 31 VAR __FiscalBeginMonth = 4 VAR __FiscalBeginDay = 1 VAR __FiscalBegin = DATE(__Year - 1,__FiscalBeginMonth,__FiscalBeginDay) VAR __FiscalEnd = DATE(__Year, __FiscalEndMonth,__FiscalEndDay) RETURN SUMX(FILTER('Table',[Date] >= __FiscalBegin && [Date] <= __FiscalEnd),[Column])No sir.
Suppose my report date is today, Then I want to add one more column which contains current fiscal year end date (31-03-2021)REPORTDATE CURRFISCALYEAREND 09-01-2015 31-03-2015 09-05-2015 31-03-2016