topic Year End Date From Text column in DAX Commands and Tips

Year End Date From Text column

suyogbi — Thu, 14 Oct 2021 11:28:47 GMT

Hi All,

I have Column which has Year value its type is Text.

I want to extract Year end date based on this column values.

if i convert it to Date it is giving wrong dates or values.

Quick help is appriciated.

Thanks in Advance.

Suyog

PaulOlding — Thu, 14 Oct 2021 11:33:15 GMT

How about:

Year End = DATE('Table'[Year], 12, 31)

suyogbi — Fri, 15 Oct 2021 07:20:49 GMT

Thank you PaulOlding for the quick reply, your reply solved my problem.

Thanks a Ton.

Regards,

Suyog