Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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
Need Help
  • Vvelarde's avatar
    Vvelarde
    6 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)
 
REPORTDATECURRFISCALYEAREND
09-01-201531-03-2015
09-05-201531-03-2016
 
Vvelarde's avatar
Vvelarde
Community Champion
6 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks bro, it worked.