Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have fetched ata from data source as text. In the power Query I want to conver it into a date
in the first row actual date 2024-10-01 and in the second row 2024-09-01
I tried to use date.Fromtext function but it is giving an error
Help is really appreaiate. @amitchandak @Greg_Deckler @Ashish_Mathur
Thank you so much in advance.
Hi,
I just changed the data type and it worked fine. See the images below
Hi @Anonymous
You could use ,
CONVERT Dax Function.
it will crack your queries
Thanks,
Thennarasu
The Date.FromText function expects the text date to be in a specific format.
To convert the text date in the format "2024-10-01" into a date in Power Query, you can try the following steps:
If you still encounter issues with the conversion, please provide me with more details about the error message that you are receiving, and the steps that you have followed so far.
Thank you so much for you reply @MAwwad
I could follow till step no. 4
It would be really nice if you can explain the step 5 with more details.
I am attaching current screen shot of the power query page
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
95 | |
92 | |
35 | |
28 |