cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Power BI Date format as "yyyymmdd"

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

3 REPLIES 3
Highlighted
Responsive Resident
Responsive Resident

Re: Power BI Date format as "yyyymmdd"

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.

Highlighted
Helper I
Helper I

Re: Power BI Date format as "yyyymmdd"

Hi Salva,

 

I tried it, the moment I use FORMAT('Calendar'[Date],"yyyymmyy") then the Data Type changes to "Text", any ideas?

 

Thank you

Highlighted
Resolver II
Resolver II

Re: Power BI Date format as "yyyymmdd"

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 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors