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.
How do I return a table excluding all rows where [Revenue] is blank, see example below. Which DAX function?
Customer | Revenue | Disbursement | DateMonth |
1 | 156 | 201701 | |
2 | 365 | 18 | 201702 |
3 | 32 | 201703 | |
3 | 69 | 201704 | |
2 | 152 | 54 | 201705 |
5 | 325 | 21 | 201706 |
4 | 145 | 69 | 201707 |
2 | 262 | 58 | 201708 |
3 | 45 | 201709 | |
6 | 326 | 52 | 201710 |
1 | 52 | 201711 | |
1 | 123 | 201712 |
Solved! Go to Solution.
Hi,
This can be done without a DAX formula. In Power Query, one can simply filter the revenue column on >0.
Hi @David_1970
Please try this calculated table
NewTableName = FILTER(Table1, 'Table1'[Revenue]<> BLANK() )
Hi @David_1970,
As I tested, the formula @Phil_Seamark posted is right. Please click "New Table" under modeling on Home page(highlighted in yellow background), type the formula, you will get expected result.
Table = FILTER(Table1,Table1[Revenue]<>BLANK())
Best Regards,
Angelia
Hi @David_1970,
As I tested, the formula @Phil_Seamark posted is right. Please click "New Table" under modeling on Home page(highlighted in yellow background), type the formula, you will get expected result.
Table = FILTER(Table1,Table1[Revenue]<>BLANK())
Best Regards,
Angelia
Hi @David_1970
Please try this calculated table
NewTableName = FILTER(Table1, 'Table1'[Revenue]<> BLANK() )
Hi,
This can be done without a DAX formula. In Power Query, one can simply filter the revenue column on >0.
NewTableName = SUMMARIZE(
FILTER(Table1,'Table1'[Field1]<> BLANK()),
'Table1'[Field1],
‘Table1’[Field2]
etc.
)
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 |
---|---|
105 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |