Forum Discussion
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
Super User
Super Useralinesilva2
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" )
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
alinesilva2
Share some sample date format in text, I will show how to convert it.My problem is in this part of the code
- Fowmy
alinesilva2
Please provide explanation and the expected result