topic Text for past and Date for present and future in DAX Commands and Tips

Text for past and Date for present and future

joshua1990 — Sun, 05 Mar 2023 14:12:01 GMT

Hi all!

I have a column with a lot of dates. Now I would like to add a calculated column that displays "Past" if the Date if in the past. If the date is today or in the future, I would like to see the Date.

How would you do that?

Re: Text for past and Date for present and future

ValtteriN — Sun, 05 Mar 2023 14:21:01 GMT

Hi,

This should do the trick:

Past = IF([Date]<TODAY(),"Past",FORMAT([Date],"DD-MM-YYYY"))

Here I am using format to avoid "variant type data" error:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Text for past and Date for present and future

FreemanZ — Sun, 05 Mar 2023 14:42:56 GMT

hi joshua1990

try to add a column like:

Column = IF([Date]<TODAY(), "Past", FORMAT([Date], "m/d/yyyy" ))

it worked like:

the sequence of "m/d/yyyy" depends on your preference.