topic Re: Convert YYYYMM to Date in DAX Commands and Tips

Convert YYYYMM to Date

Anonymous — Sun, 22 Jan 2023 12:47:33 GMT

Hi all,

I have the following column, withthe year and the week number and I'm looking to convert this to a date where the date is the first date of the given week (ie 202304 would be 23/01/2023). Is this possible using DAX and perhaps a new column?

Any help would be much appreciated! Thanks

Re: Convert YYYYMM to Date

FreemanZ — Sun, 22 Jan 2023 13:28:06 GMT

hi Anonymous

try to add a column like this:

DATE = DATE( LEFT([YYYYMM], 4), 1,1) + (RIGHT([YYYYMM],2)-1)*7 + 1

Re: Convert YYYYMM to Date

Anonymous — Mon, 23 Jan 2023 10:03:47 GMT

This worked, thank you so much!