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.
The formula used is given in the screenshot. If length, width, height >0 then "YES" plus "No"
Els
Solved! Go to Solution.
Hello @sbhan4 ,
Try this:
GPPCheck =
SWITCH(
TRUE(),
SUM(GPP[Height]) <= 0 ||
SUM(GPP[Lenght]) <= 0 ||
SUM(GPP[Width]) <= 0,
"No",
"Yes"
)
I hope it helps.
Best regards
Fernando
If it helped, please consider liking the post and mark it in response.
@Anonymous
Are you using Width or Weight?
F
@Anonymous
You're not showing the Width column in your screen-shot. It'd be helpful if you share a sample of your data.
F
Hello @sbhan4 ,
Try this:
GPPCheck =
SWITCH(
TRUE(),
SUM(GPP[Height]) <= 0 ||
SUM(GPP[Lenght]) <= 0 ||
SUM(GPP[Width]) <= 0,
"No",
"Yes"
)
I hope it helps.
Best regards
Fernando
If it helped, please consider liking the post and mark it in response.
@calerof Hello sir,
I tried your solution. Everything showing "YES" only. As you see in the screenshot,
if any of the column value is 0 or blank = NO
Each column has a value >0 then only YES. can you share your pbix file.
Hi @Anonymous ,
You are doing it the opposite way, and that's fine. You just have to change the OR for AND.
Cheers,
Fernando
What is your code for GGP now?
Hi,
As you can see in the screenshot, the code is the same as you told. Now I changed || to &&.
Please provide a sample of your data with your pbix file to help you.
F
@calerof I have updated the screenshot with a width column. Please help me with that.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |