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?
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

    • Fowmy's avatar
      Fowmy
      Super User
      2 years ago

      alinesilva2 

      Share some sample date format in text, I will show how to convert it.


      • alinesilva2's avatar
        alinesilva2
        Regular Visitor
        2 years ago

        My problem is in this part of the code