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.
Bonjour,
J'ai une table avec plusieurs lignes pour un même tiers.
J'ai besoin de créer une nouvelle table avec une ligne par tiers, une colonne intitulée "tiers" et une colonne sommant les valeurs d'une colonne de la table d'origine.
J'arrive à créer la table avec la fonction SUMMARIZECOLUMNS, mais je ne trouve pas de fonction pour avoir la somme des valeurs d'une colonne de la table d'origine.
Help !
Solved! Go to Solution.
Hi Claire_Urruty,
Here's a solution:
Create a new table Table2, with trhe following formula:
Table2 = SUMMARIZE('Table',
'Code_Tiers','Libellé Famille',
"Ha",SUM('Table'[Ha]))
Note that I've assued that the input table is named Table.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Manguilibe KAO
Hi Claire_Urruty,
Could you give some input data and the corresponding output you want?
Best regards.
Hi,
Input data :
Code tiers | Libellé Famille | Libellé Production | Ha |
0080000991 | Maïs | MAIS ROUX CLASSE A IRRIGUE | 17,00 |
0080000991 | Maïs | MAIS ROUX CLASSE A NON IRRIGUE | 4,00 |
0080000991 | Maïs | MAIS WAXIPRO IRRIGUE | 11,00 |
0080000991 | Maïs | MAIS WAXY IRRIGUE | 10,50 |
0080000991 | Maïs | MAIS WAXY NON IRRIGUE | 3,00 |
Output data :
Code tiers | Libellé Famille | Ha |
0080000991 | Maïs | 45,50 |
Thanks for your help.
Hi Claire_Urruty,
Here's a solution:
Create a new table Table2, with trhe following formula:
Table2 = SUMMARIZE('Table',
'Code_Tiers','Libellé Famille',
"Ha",SUM('Table'[Ha]))
Note that I've assued that the input table is named Table.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Manguilibe KAO
It's ok, your post helps me. Thanks a lot !
Have a good day.
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |