Forum Discussion
How to Capture Individual Numbers in Dynamic Arrays per Cell
Good day, I would like to ask if Power BI can capture the individual IDs in an entry with a dynamic count of ID values in an entry: Operator Shift 1 1 1,2 2 1,3,5 1 2 2 ...
nidquival , One option it split the first column of the first table into rows in power query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
amitchandak, can this be done automatically using power query? The values will be coming from a database so the transactions will be constantly appended.