@aaydin100 When I copy paste your date sample so by default PBI accepts it as Date/Time format. In case if it is Text for you so you can try this DAX in new column:
Text to Date Column = LEFT('Date'[Date],10)
Then mark this newly created column to Date from Data type option.
@aaydin100 When I copy paste your date sample so by default PBI accepts it as Date/Time format. In case if it is Text for you so you can try this DAX in new column:
Text to Date Column = LEFT('Date'[Date],10)
Then mark this newly created column to Date from Data type option.
Hi,
I did not have any problem in having it as a Date, please elaborate or share the file
Regards,
Ritesh
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
