Hello I am looking to make a measure for a new column 'In Compliance' that tells if an action Item was completed on or before the date needed, so somthing like;
Date completed - Date needed = Yes/No
For example
1 ACCEPTED SOLUTION
Hi @Anonymous ,
Use this code for a new calculated column:
In Compliance = IF('Table'[Date Completed] <= 'Table'[Date Needed], "Yes", "No")
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Hi @Anonymous ,
Use this code for a new calculated column:
In Compliance = IF('Table'[Date Completed] <= 'Table'[Date Needed], "Yes", "No")
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
