The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
if ([Outcome Date]-[#"Treatment Registrar Date#(lf)(please fill in date format: 1-Jan-2021)"]) >150 then "OK" else "Check"
is not working
Solved! Go to Solution.
Duration.Days([Outcome Date]-[#"Treatment Registrar Date#(lf)(please fill in date format: 1-Jan-2021)"]) >150
Thank you. It working indirectly.
I want to use if condition for that logic
[Date 2] - [Date 1]= result >150 days, "OK", "Check"
Duration.Days([Outcome Date]-[#"Treatment Registrar Date#(lf)(please fill in date format: 1-Jan-2021)"]) >150