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, I have a column that's wierdly the excel 'math month' so like 43220 and 43251 and such. I need to convert those back into actual human dates... I tried format and date but couldn't get them to work. Any ideas?
Hi @CapnShanty,
Are those values formatted as "Whole number" after imported into desktop?
If so, please directly change the data type to "Date".
Best regards,
Yuliana Gu
Try to create another column
month_NUMBER = MONTH(CELL 43220)
I have checked and that number is the 30th of April of 2018
and if you create the column for MONTH(COLUMN NUMBERS) and then apply format like "general" or "decimal" then you can see a 4.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |