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
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors