Forum Discussion

UK_User123456's avatar
UK_User123456
Icon for Resolver I rankResolver I
7 years ago
Solved

Financial Year

Hi All,   How would I go about finding out the Finanacial years based on a date. My financial reporting starts on the 4th Apr and ends 31st Mar. I have a column of dates that range from 2001 to 201...
Need Help
  • evandrocunico's avatar
    evandrocunico
    7 years ago

    Hi, UK_User123456 

     

    FY = var __fy = if(ISBLANK(DimDate[Date]);BLANK(); if (MONTH(DimDate[Date]) >= 4; YEAR(DimDate[Date])&"/"&YEAR(DimDate[Date])+1;YEAR(DimDate[Date])-1&"/"&YEAR(DimDate[Date])))
    return __fy
     
    regards.
evandrocunico's avatar
evandrocunico
Icon for Resolver III rankResolver III
7 years ago

Hi, UK_User123456 

Create a new column:

 

FY = var __fy = if (MONTH(DimDate[Date]) >= 4; YEAR(DimDate[Date])&"/"&YEAR(DimDate[Date])+1;YEAR(DimDate[Date])-1&"/"&YEAR(DimDate[Date]))
return __fy
 
regards.
  • UK_User123456's avatar
    UK_User123456
    Icon for Resolver I rankResolver I
    7 years ago

    Hi, 

     

    Many thanks for this, works great, but how do I apply return blank if there is no gift date?

     

    TIA

    • evandrocunico's avatar
      evandrocunico
      Icon for Resolver III rankResolver III
      7 years ago

      Hi, UK_User123456 

       

      FY = var __fy = if(ISBLANK(DimDate[Date]);BLANK(); if (MONTH(DimDate[Date]) >= 4; YEAR(DimDate[Date])&"/"&YEAR(DimDate[Date])+1;YEAR(DimDate[Date])-1&"/"&YEAR(DimDate[Date])))
      return __fy
       
      regards.