Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm having trouble with this IF AND statement that I had on excel transfering it to power query Check below:
=IF(AND(AG5="",J5="FLOAD",F5="OCPD"),M5)
Check out Date (AG5) = "blank cell"
Stock Status (J5) = "FLOAD"
Regular Status (F5) = "OCPD"
SPEND (M5) = "140"
I tried using this formula below but I keep getting FALSE in the Power Query column:
IF [Trailer Check Out]="" AND [Trailer Stock Status]="FLOAD" AND [Trailer Status]="OCPD" THEN [Detention Spend] ELSE "FALSE"
ENDIF
Your help would be greatly appreciated!! 🙂
Solved! Go to Solution.
That doesn't look like M code with the endif, the syntax should be:
if [Trailer Check Out] = null and [Trailer Stock Status]="FLOAD" and [Trailer Status]="OCPD" then [Detention Spend] else "FALSE"
Thank you!
That doesn't look like M code with the endif, the syntax should be:
if [Trailer Check Out] = null and [Trailer Stock Status]="FLOAD" and [Trailer Status]="OCPD" then [Detention Spend] else "FALSE"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.