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.
Hi,
I have a table with product number, qty and ID and another table with a number n (time to repeat) and m (start number)
I would modify first table repeating
For example
Product number qty ID
A 2
B 4
n=4 m=7
So I would have
Product number qty ID
A 2 7
A 2 8
A 2 9
A 2 10
B 4 7
B 4 8
B 4 9
B 4 10
Someone can help me?
Thanks
Solved! Go to Solution.
somethink like this?
let
Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJSitWJVnICskzALGcgy1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [prod = _t, qty = _t]),
m=7,
n=4,
#"Aggiunta colonna personalizzata" = Table.AddColumn(Origine, "id", each List.Range({1..100},m-1,n)),
#"Tabella id espansa" = Table.ExpandListColumn(#"Aggiunta colonna personalizzata", "id")
in
#"Tabella id espansa"
somethink like this?
let
Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJSitWJVnICskzALGcgy1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [prod = _t, qty = _t]),
m=7,
n=4,
#"Aggiunta colonna personalizzata" = Table.AddColumn(Origine, "id", each List.Range({1..100},m-1,n)),
#"Tabella id espansa" = Table.ExpandListColumn(#"Aggiunta colonna personalizzata", "id")
in
#"Tabella id espansa"
Thank you is what I need
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |