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.
Hello,
Any ideas about how to fix a date that was wrongly entered into a spreadsheet (data source) and it is connected to the power bi dashboard:
the format I keep using is dd-mm-yyyy but other people who use this spreadsheet do copy-paste from different sources and then the date reaches me in mm-dd-yyyy format
ex:
date on the sheet and thus power bi: period start: 20-5-2022, period end 7-1-2022
it should be: period start: 20-5-2022, period end 1-7-2022
what i usuallly do is strip it out in power query so split the date field into its 3 parts, and re concatenate it in the correct order.
Proud to be a Super User!
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |