This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.