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.
Good day,
Please will you provide me solution for below challenge
I do have "Date" column in Calendar table / data set (Power BI generated Date table). I would like to create new date column in "Calendar" table / data set, the new column's DATA TYPE should be "Date" and the FORMAT should be "yyyymmdd"
Thank you
I dont think it is possbile to make "20180901" as a date type.
is it a solution to make 2 columns? 1 as a date type for calculation and 1 for displaying?
---
update
maybe this could work: https://www.oraylis.de/blog/local-date-formats-in-power-bi
Hello,
If you go to the modeling tab, under format, you have yyyy-MM-dd, if that doesnt suit your needs, you could create a calculated column, and format([date],"yyyymmdd")
Regards,
Salva.
Hi Salva,
I tried it, the moment I use FORMAT('Calendar'[Date],"yyyymmyy") then the Data Type changes to "Text", any ideas?
Thank you
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |