The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi Community,
I have this calculated column:
WeekEnding = FORMAT(DimCalendar[Date] - MOD(DimCalendar[Date]-1,7) + 6,"YYYY-MM-DD")
So my intention is really to have a date in text format. I've even set Data Type and Format to Text.
My challenge though is when I export the table ( . . . > Export Data) and now I guess this is more of an Excel question rather than PowerBI or maybe there's a way around PowerBI to overcome this.
1. When I opened the exported data (csv) in notepad, the date(string) is in its "YYYY-MM-DD".
2. BUT if I use excel to open the CSV file it turns it into m/d/yyyy.
Anyway and again maybe this is really more of an Excel inquiry and I'm reposting this in an Excel forum just thought maybe I can find an answer here.
Thank you.
Try adding an apostrophe infront of the data.
EDIT: apostrophe is '
Yes, I know what you mean by this but this won't work because you'll not lose the apostrophe.
Example:
WeekEnding = CONCATENATE("'",FORMAT(DimCalendar[Date] - MOD(DimCalendar[Date]-1,7) + 6,"YYYY-MM-DD"))
Expected output(when CSV file is opened in Excel):
YYYY-MM-DD where aposthrope should have forced the date to a text type
But what you'll see is:
'YYYY-MM-DD, aposthrope is retained. It will only disappear if you select the cell, hit F2 and press enter key.
Did you every get a solution to this, I have the same problem.
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
153 | |
137 | |
131 | |
81 | |
61 |