Forum Discussion

alinesilva2's avatar
alinesilva2
Regular Visitor
2 years ago

text to date

Hello!
I need to change the variable of an api I'm working on from text to date, the code is in DAX, how do I do it?

8 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    alinesilva2 

    What you are sharing is the "M" code in Power Query. The Date,ToText function is correct. Is question regarding how to do the same in DAX then

    FORMAT ( Table[Date] , "yyyy-mm-dd" )



    • alinesilva2's avatar
      alinesilva2
      Regular Visitor
      2 years ago

      Hi!

       

      I would like to create a variable that identifies the current date, in this case today, and another variable that is the date current -35 days, so that I can do an update automatically, but to do this I believe that I must first
      being able to convert the Day field into date format and not Text It is currently in Text format

  • alinesilva2's avatar
    alinesilva2
    Regular Visitor
    2 years ago

    I would like to create a variable that identifies the current date, in this case today, and another variable that is the date current -35 days, so that I can do an update automatically, but to do this I believe that I must first
    being able to convert the Day field into date format and not Text It is currently in Text format