Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
alinesilva2
Regular Visitor

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?

2023-12-27_10h14_36.png

8 REPLIES 8
alinesilva2
Regular Visitor

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
Super User
Super User

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



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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 

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


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

2023-12-27_10h14_36.png

My problem is in this part of the code

@alinesilva2 
Please provide explanation and the expected result

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

 

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.

alinesilva2_0-1703786587237.pngalinesilva2_1-1703786611265.pngalinesilva2_2-1703786630459.png

 

@alinesilva2 

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

Fowmy_0-1703829196522.png
You get the result

Fowmy_1-1703829239934.png

 




 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.