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.
I have a three column i want a result like it select" T " from col1- and that should not contain 0 and null from col2 and col3
col1 col2 col3
A 1 null
A 2 0
T 3 0
T 0 null
T null 6
Hi @Anonymous ,
what's your meaning of "not contain 0 and null from col2 and col3",from your description, I know you want to filter col1,but I don't understand "not contain o and null", because unless you delete col2 and col3, if you filter on this table, it will show the whole row.
So can you give me your expected result? so that i can know what you want.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
In the Query Editor, right click on the first column's heading and select "Unpivot Other Columns". Filter the Value column with the criteria >0. Does this help?
@Anonymous Maybe:
col4 =
SWITCH(TRUE(),
[col1] = "T" && [col2] > 0 && [col3] > 0, TRUE(),
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.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |