Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |