Forum Discussion

siddrow's avatar
siddrow
Helper III
3 years ago
Solved

If else DAX statement in data modelling tab

Hi   I'm struggling to work out how to write a DAX formula for what I need.   I have a "Current Financial Year" column (created in data modelling tab) which is whole number format (e.g. 2023) and...
Need Help
  • siddrow's avatar
    siddrow
    3 years ago

    Finally worked it out:

     

    = IF(NOT(ISBLANK([FY Final])),if([FY Final]-[Current Financial Year]<=25,"Yes","No"))
siddrow's avatar
siddrow
Helper III
3 years ago

Current DAX formula I have tried which isn't working:

 

IF(ISBLANK([FY Final]),BLANK(),if([FY Final]-[Current Financial Year]<=25),"Yes","No"))
siddrow's avatar
siddrow
Helper III
3 years ago

Finally worked it out:

 

= IF(NOT(ISBLANK([FY Final])),if([FY Final]-[Current Financial Year]<=25,"Yes","No"))