Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to change text data type to date data type for calculated column

Hi Community people, I have created one calculated column for financial year end date using below:   FYMaxDateEND = IF('Query1'[End - Month]>=4 , "31/03/" &  'Query1'[End - Year]+1,IF('Query1'[En...
Need Help
Show and Tell
Tips and Tricks
  • tex628's avatar
    tex628
    7 years ago
    FYMaxDateEND = 
    IF('Query1'[End - Month]>=4 , DATE([End - Year]+1 , 3 , 31),
    IF('Query1'[End - Month]<=3 , DATE([End - Year] , 3 , 31))
tex628's avatar
tex628
Community Champion
7 years ago
FYMaxDateEND = 
IF('Query1'[End - Month]>=4 , DATE([End - Year]+1 , 3 , 31),
IF('Query1'[End - Month]<=3 , DATE([End - Year] , 3 , 31))
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you very much. it's working now