Forum Discussion

beaverbuzz85's avatar
beaverbuzz85
Regular Visitor
3 years ago

Troubleshooting Simple Conversion of String to Date

Hello,    I am trying to solve a seemingly simple issue. I am trying to convert the following to a year.   1999/2000 to 2000.    1999/2000 (string)   My calculated column is this:  Tax Year...
SamInogic's avatar
SamInogic
Icon for Super User rankSuper User
3 years ago

Power BI allows the DATEVALUE DAX formula with parameter as Text, which includes date value in MM/DD/YYYY format, so you need to add the below expression:

 

DateVal = DATEVALUE("01/01/" & RIGHT("1999/2000", 4))

Please refer to the below screenshot for the same.

 

 

Thanks!

Inogic

Innovative Logic  

Web: www.inogic.com/services/

Blog: http://www.inogic.com/blog

twitter: @inogic