topic Re: text to date in DAX Commands and Tips

text to date

alinesilva2 — Wed, 27 Dec 2023 14:24:25 GMT

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?

Re: text to date

Fowmy — Wed, 27 Dec 2023 19:37:56 GMT

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" )

Re: text to date

alinesilva2 — Thu, 28 Dec 2023 13:23:38 GMT

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

Re: text to date

alinesilva2 — Thu, 28 Dec 2023 13:24:23 GMT

Re: text to date

Fowmy — Thu, 28 Dec 2023 13:33:17 GMT

alinesilva2

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

Re: text to date

alinesilva2 — Thu, 28 Dec 2023 13:39:42 GMT

My problem is in this part of the code

Re: text to date

Fowmy — Thu, 28 Dec 2023 13:44:50 GMT

alinesilva2
Please provide explanation and the expected result

Re: text to date

alinesilva2 — Thu, 28 Dec 2023 18:04:04 GMT

Currently I have a field called "DAY" and this field is configured as text type in my API (which is
my data source), I need to convert this field which is in the format YYYY-MM-DD (text) to DD/MM/YYY (date), as
This way I can automate my query.

Below is an example of one of my attempts to create these variables.

In this case, the period of time I need is from the day before the current day to 35 days before the current day, in order to have the
Automatic Update.

Re: text to date

Fowmy — Fri, 29 Dec 2023 05:54:09 GMT

alinesilva2

If you date is in text as yyyy-mm-dd then just chagne the data type to date:

You get the result