How to change YYYYMMDD into date format?

No No,

u r trying to create in power Query window. so only it throws error.

i was gave u DAX Query.

U have to create new column in Development environment .

1. Create via Modelling Tab.

2. Right click on Table and choose new colum and apply the formula

Let me know if any help

assume:  [date] is in the following format:  yyyymmdd

create a new column named [dateFormatted] and apply the formula as follows:

• dateFormatted = Date(Left([date],4),Right(left([date],6),2),right([date],2)

select the new column and change its type to date as follows:

[dateFormatted] will now be of type date,   formatted as:   dd Mmm yyyy