Forum Discussion

jhaast's avatar
jhaast
Helper II
6 years ago
Solved

Create a table with repeated labels

Hi everybody,   I'm trying to create a new table with repeated labels. Table A is a table with dates, Table B is a table with the business units. I want to create a table which repeats the date v...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    OK, you have two choices:

    1. Create the date table in Power Query and Add the column as in the first post.

     

    Or

    2. Create the new table in DAX which would be CROSSJOIN (Table A, Table B)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You can simply add a column with this formula:

=Text.Repeat("a",[Column5])

In column 5 should be the count you want for rows to be duplicated.

Then, from transform tab, split the new column by number of characters, use 1 char split, but from advanced settings, make sure you split into rows, not into columns, this will duplicate all other columns.

Now you can remove the additional column, to diplay only the results.

I can be done with custom M code, with List.Accumulate, but it's easier via interface, see the attached file.