Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Seems like this should be easy but can't quite get it. Have text in the following format that needs to be converted to a date format (last day of the month). Thank you!
Current Format (MMM-YY) Desired Output
Dec-19 12/31/19
Jan-20 1/31/20
Feb-20 2/28/20
Solved! Go to Solution.
@asebes and to add to @mahoneypat 's reponse, here is a DAX calculated column version:
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
I wanted to do this in Power Query instead of DAX and creating a Custom Column with this formula worked for me (credit to ChatGPT for the assist):
=Date.FromText("01-"&[YourTextColumnHere])
@asebes and to add to @mahoneypat 's reponse, here is a DAX calculated column version:
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
You can add a custom column in the query editor with this formula to get your desired result.
= Date.EndOfMonth(Date.From([Current Format]))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
75 | |
51 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |