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 besoin de votre aide.
Ma table dispose de 3 colonnes : Fullsize, Brand, EanCode
FullSize | Brand | EanCode |
205/55 R 16 | Continental | 35645671819 |
205/55 R 16 | Continental | 15614881789 |
205/55 R 16 | Michelin | 15489174861 |
205/55 R 16 | Michelin | 35645671819 |
Je veux faire ressortir un tableau :
En ligne : Fullsize (autant de ligne fullsize que d'EanCode)
En colonne : Brand
En valeur : EanCode (qui multiplie les lignes si plusieurs EanCode par Brand)
FullSize | Michelin | Continental |
205/55 R 16 | 15489174861 | 35645671819 |
205/55 R 16 | 35645671819 | 15614881789 |
Actuellement j'ai réussi seulement à concaténer les valeurs par colonne :
Avec cette formule :
Solved! Go to Solution.
what you woud need to do is add an index columns that increments per Brand and then use that index in your visual rows.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIw1Tc1VQhSMDRT0lFyzs8rycxLzStJzAHyjE3NTEzNzA0tDC2VYnXwqzU0NTM0sbAwNLfAptY3MzkjNSczD6zQxMLS0NzEwswQv0IU22MB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [FullSize = _t, Brand = _t, EanCode = _t]),
#"Grouped Rows" = Table.Group(Source, {"Brand", "FullSize"}, {{"Rows", each _, type table [FullSize=nullable text, Brand=nullable text, EanCode=nullable text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Rows], "Index", 0, 1, Int64.Type)),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
#"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"FullSize", "Brand", "EanCode", "Index"}, {"FullSize", "Brand", "EanCode", "Index"})
in
#"Expanded Custom"
If these two products really have the same EAN then your request is ambiguous and cannot be implemented.
@lbendlin d'accord merci du retour.
Dans ce cas avec des données uniques comme celles ci, est ce possible et comment ?
Still no. You need columns that uniquely identify each tire size. FullSize has all the same values.
Hello @lbendlin,
c'est normal d'avoir les mêmes données FullSize. La valeur unique est la concaténation de EanCode, Brand et FullSize.
Ce qui nous intéresse c'est d'arriver à sortir ce tableau :
FullSize | BRIDGESTONE | CONTINENTAL |
205/55 R 16 91V | 3286340291620 | 4019238456080 |
205/55 R 16 91V | 3286342615516 | 4019238339802 |
205/55 R 16 91V | 3286340291613 | |
205/55 R 16 91V | 3286340306416 |
what you woud need to do is add an index columns that increments per Brand and then use that index in your visual rows.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIw1Tc1VQhSMDRT0lFyzs8rycxLzStJzAHyjE3NTEzNzA0tDC2VYnXwqzU0NTM0sbAwNLfAptY3MzkjNSczD6zQxMLS0NzEwswQv0IU22MB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [FullSize = _t, Brand = _t, EanCode = _t]),
#"Grouped Rows" = Table.Group(Source, {"Brand", "FullSize"}, {{"Rows", each _, type table [FullSize=nullable text, Brand=nullable text, EanCode=nullable text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Rows], "Index", 0, 1, Int64.Type)),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
#"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"FullSize", "Brand", "EanCode", "Index"}, {"FullSize", "Brand", "EanCode", "Index"})
in
#"Expanded Custom"
@lbendlin Merci ça m'aide.
mais à la place de la colonne index dans le tableau je dois avoir FullSize, pour que les utilisateurs puissent filtrer sur la dimension
thanks for your help !
Your sample data has the same EAN code for two of the tires. I don't think that is accurate.
Bonjour @lbendlin,
C'est correct et c'est pourquoi nous avons besoin de toute la liste d'EAN par Brand en colonne et par FullSize en ligne.
Merci pour votre aide
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 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |