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.
Hello all,
I'm trying to write a custom column formula in PowerBI desktop Query Editor to do a calculation. I have the following columns:
If the group of cattle is "NHTC/All Natural" and they are "Steers" (males), I want to take their "Base Weight" + (100*0.1).
If the group of cattle is "NHTC/All Natural" and they are "Heifers" (females), I want to take their "Base Weight" + (100*.09).
Otherwise I wish to leave the new column empty ("null").
When I run this formula the way it is below, it works correctly in that it only selects those groups which are "NHTC/All Natural" but it is taking the "Base Weight" from the "Heifers" and adding it to (100*0.1) instead of (100*0.09).
Any tips on how I can alter this to get "Base Weight" from "Heifers" added to (100*0.09)?
Solved! Go to Solution.
Probably you are just missing the paranthesis in your formula.
Just change it to follow the below pattern -
if ((x=XXX or y=YYY) AND z=zzzz) THEN BASEWt + (100*.1)
else if ((x=XXX or y=YYY) AND z=zzzz) THEN BASEWt + (100*.09)
else null
Hope, this helps!
That solved it! Thank you so much, I sincerely appreciate your help!
Probably you are just missing the paranthesis in your formula.
Just change it to follow the below pattern -
if ((x=XXX or y=YYY) AND z=zzzz) THEN BASEWt + (100*.1)
else if ((x=XXX or y=YYY) AND z=zzzz) THEN BASEWt + (100*.09)
else null
Hope, this helps!
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.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |