Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi there,
Can someone advise how I can rectify this statement please? If the agreement end date is in this year, then I want the custom column to display 'Active', otherwise 'Inactive'.
Solved! Go to Solution.
(pay attention to case sensitivity)
= if Date.IsInCurrentYear([Agreement End Date]) then "Active" else "Inactive
--Nate
View solution in original post
Thank you very much @Anonymous
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.
