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 nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hi,
I want to create a filter that uses 2 different fields/columns.
I have the following table
| id | actual | budget |
| 1 | 10 | 20 |
| 2 | 0 | 50 |
| 3 | 0 | 0 |
| 4 | 20 | 23 |
I don't want to see id number 3, I want my table to filter out rows when the actual = 0 and budget = 0
Thanks !
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 21 | |
| 20 |