Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi community,
I am doing an operation to obtain the summation of one of my fields, it must meet certain filters, but in the end it must bring me the totalized in a unique way. For example, I have my data as image 1 and I need to have the total as image 2.
Thanks for your help!
(image1)
(image2)
You can create a new table like
summarize(filter(table, table[ILE00]="MIN"),table[BWART],table[AUFNR],table[ISM00],table[ILE00])
Appreciate your Kudos.
Hi @amitchandak , thanks for your help, but the result throws me a table and I need to do the sum of a column of that summary table.
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |