Forum Discussion
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...
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)
The date table A is created after the Power Query menu, with the new table function and the following formula:
Dates = CALENDAR (DATE(2003;01;1); DATE(YEAR(TODAY())+1;12;31))
The Business Unit table B is imported from a SQL database with Power Query.
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)