Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Dear PBI users, good morning.
I need a help with this issue, I would like to create a new table using dax that would repeat the value of another column based on another. To exemplify:
Current table:
Product | Pallet Quantity |
A | 3 |
B | 2 |
Desired Result:
Product | Pallet Quantity |
A | 1 |
A | 1 |
A | 1 |
B | 1 |
B | 1 |
How can I do that in DAX?
Thank you in advance!
Solved! Go to Solution.
@Anonymous Try this. PBIX is attached below signature.
Table 2 =
SELECTCOLUMNS(
ADDCOLUMNS(
GENERATE(
DISTINCT('Table'[Product]),
GENERATESERIES(1,MAXX(FILTER('Table',[Product] = EARLIER('Table'[Product])),[Pallet Quantity]),1)
),
"Pallet Quantity",1
),
"Product",[Product],
"Pallet Quanitity",[Pallet Quantity]
)
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhjeqxmvgzEItNzcu?e=frRM7C
also possible in power query
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhjeqxmvgzEItNzcu?e=frRM7C
Is there a way that I could include Indexes as well?
For example
Product - Pallet Quantity - Index
A - 1 - 1
A - 1 - 2
A - 1 - 3
B - 1 - 1
B - 1 - 2
@Anonymous Try this. PBIX is attached below signature.
Table 2 =
SELECTCOLUMNS(
ADDCOLUMNS(
GENERATE(
DISTINCT('Table'[Product]),
GENERATESERIES(1,MAXX(FILTER('Table',[Product] = EARLIER('Table'[Product])),[Pallet Quantity]),1)
),
"Pallet Quantity",1
),
"Product",[Product],
"Pallet Quanitity",[Pallet Quantity]
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
38 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |