PowerBI repeat rows from table A for each date in table B

1
votes

I have two tables one contains User data and other is my dates table.
Is it possible to copy each row from users table for each date from dates table like below?

enter image description here

1
powerbipowerbi-desktop

1 Answers

1
votes

It is possible using transformations:

enter image description here

Add custom column(column formula is second table name):

enter image description here

Expand column:

enter image description here

enter image description here