Forum Discussion
combine 2 table
Hi friend
i have 2 table like these
Date table
| 01/02/2022 |
| 02/02/2022 |
| 03/02/2022 |
| 04/02/2022 |
Wave Table.
| Wave 60 |
| Wave 61 |
how can I combine these 2 table to new one like below.
| Date | Wave No. |
| 01/02/2022 | Wave 60 |
| 01/02/2022 | Wave 61 |
| 02/02/2022 | Wave 60 |
| 02/02/2022 | Wave 61 |
thank in advance for any suggestion.
4 Replies
Anonymous
You can use CROSSJOIN table function to obtain the desired resultshttps://docs.microsoft.com/en-us/dax/crossjoin-function-dax
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new table.
New Table =CROSSJOIN('Date', Wave )
