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.
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
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
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
