topic Updating a column in a table with only dates with in 365 days in DAX Commands and Tips

Updating a column in a table with only dates with in 365 days

robs67stang — Fri, 30 Jun 2023 13:34:29 GMT

Good morning. I am having issues figuring out how to format a column in a table to only show dates within 365 days of the current date, but leave the blanks in the column for the dates outside of that parameter. I need the blanks due to may pie charts uses them to calulate completed training courses versus not completed, or expired, training courses. I have included a snapshot of one of the columns I'm trying to format. All the dates are currently within 365 days, but I need them to go blank as they expire. Any help would be greatly appreciated. Thank you.

Re: Updating a column in a table with only dates with in 365 days

barritown — Tue, 04 Jul 2023 07:34:25 GMT

Hi @robs67stang,

You could create a calculated column like the one below and use it instead.

In plain text:

Calculated Column = IF ( DATEDIFF ( [Default Date], TODAY(), DAY ) < 365, [Default Date], BLANK() )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

Re: Updating a column in a table with only dates with in 365 days

robs67stang — Wed, 05 Jul 2023 19:06:02 GMT

Alexander,

That worked great. Thank you for your help!