Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Not sure if title makes sense.
I have two tables
Table1 (Manually entered query): Only one column called 'names' with company names
Table2 (Calculated table with DAX expressions): Months, Years, Quarters and Concats of these combinations
I need to create a new table or add to Table1 where for each value in Table2.Year_Quarter, Table1.names duplicate
Example:
A - 2018 Q1
A - 2018 Q2
A - 2018 Q3
A - 2018 Q4
B - 2018 Q1
B - 2018 Q2
B - 2018 Q3
B - 2018 Q4
C - ETC ETC....
Thanks in advance
Solved! Go to Solution.
Hi @RB1,
I made one sample for your reference.
1. Create a calculated column.
Table = CROSSJOIN(COMPANY,'DATE')
2. Create the calculated column in the calculated column.
Column = 'Table'[name] & " " & CONCATENATE('Table'[Year],'Table'[Q])
Regards,
Frank
Hi @RB1,
I made one sample for your reference.
1. Create a calculated column.
Table = CROSSJOIN(COMPANY,'DATE')
2. Create the calculated column in the calculated column.
Column = 'Table'[name] & " " & CONCATENATE('Table'[Year],'Table'[Q])
Regards,
Frank
Hi @RB1,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |