Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a table with a list of products and another that I generate the months and years, and I need to create a table where the products are for each month and year, as shown. How could I do it using DAX?
Product |
A |
B |
C |
Year | Month |
2022 | 1 |
2022 | 2 |
2022 | 3 |
... | ... |
2023 | 12 |
Result
Year | Month | Product |
2022 | 1 | A |
2022 | 1 | B |
2022 | 1 | C |
2022 | 2 | A |
2022 | 2 | B |
... | ... | ... |
Solved! Go to Solution.
Hi @nicolasvc ,
Using DAX you can use the CROSSJOIN sintax:
Table 2 = CROSSJOIN('Table1', 'Table2')
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @nicolasvc ,
Using DAX you can use the CROSSJOIN sintax:
Table 2 = CROSSJOIN('Table1', 'Table2')
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsIn Power Query, add a custom column to the second table (using the interface). In the dialog box put the name of the first table.
In the next step, expand the table (from the column header).
That should do it
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |