Add rows containing a list of IDs for each categories

[Anonymous]

Hello to the community,

Currently, I'm stuck with this data transformation in power query editor :

I have one table named "seasonality" with all the dates of the years :

I have a second table  named "Data Equipment" with several ID :

And I want combine this tables with this transformation : for each dates, add all rows with this IDs  

Desired result 

If someone can help me.. or offers me another solution of transformation, group by etc..

Thank you in advance !

[HotChilli · Accepted solution]

2 things:

1 - to get more detail on errors, click in the error box (not on the error) and you'll get a further details below the dataset.

2 - did you write that code yourself because there's a lot wrong with it.  I suggest deleting the step.

After that, click the 'custom column' on the Add Column menu.  In the formula box put the name of the other table (if you write # , intellisense should offer you the name). Click OK.

If that works, expand the column header to return the correct field.

[Anonymous]

Thanks a lot ! It's working ! 😁

I'm beginner with Power BI so I didn't know this trick..

[HotChilli]

I can help if you tell me what you've got so far.   Any errors?  

[Syndicate_Admin]

Here is my error

[Anonymous]

Here is my error

[HotChilli]

In seasonality, add custom column and just put the name of the 2nd table.  You can then expand the header.

If the 2nd table has many colmuns but you just want to add one then just put the Table[columnName] in the Add custom column code box.  You will then be able to expand the list to new rows

[Anonymous]

This solution not working or may be I didn't understand