Forum Discussion
SAPpowerbi
4 years agoHelper II
Count without blank rows
Hello Team , Please help me for below issue . Source data in mtrix Table - Service line A B C Client Name (Revenue) (Revenue) (Revenue) HP 100 10 Asus 10 ...
- 4 years ago
Hi SapPowerBI
No DAX is required ! ๐
In Power Query unpivot you table to this ...
Then create a visual table
with Service and Count Value.
I will send an example in few minutes
speedramps
4 years agoSuper User
Hi SapPowerBI
No DAX is required ! ๐
In Power Query unpivot you table to this ...
Then create a visual table
with Service and Count Value.
I will send an example in few minutes
parry2k
4 years agoSuper User
speedramps what is the thought process to aggregate the data on PQ, just trying to understand?