topic Re: Date format in text column in DAX Commands and Tips

Date format in text column

Bergh — Thu, 12 May 2022 11:36:46 GMT

Hi.
I have this one: Test = CONCATENATE(related(apdv035_ppap_dim[_Exist_PPAP]), ", "& (RELATED(apdv302_part_period_dim[ea_minus_40])))

The column is text.

The output is: No, 12/5/2022

But I want it like: No, 2022-5-12

How??

Arul — Thu, 12 May 2022 12:22:36 GMT

try this

Test = CONCATENATE(related(apdv035_ppap_dim[_Exist_PPAP]), ", "& (format(RELATED(apdv302_part_period_dim[ea_minus_40]),"YYYY-M-D")))

Whitewater100 — Thu, 12 May 2022 12:28:51 GMT

Hi:

Can you try

Result = DATEVALUE([Test])

Also there are formatting options on top ribbon:

I hope this helps..