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.
I am trying to a new table out of two exisiting tables. Table 1 has all the dates & Table 2 has the department & cost. All the departments & costs are static for the year but I need there to be a department and cost for each date (see example). Is there a way to append or merge these tables?
TABLE 1: | ||
DATE | ||
11/4/2022 | ||
11/18/2022 | ||
12/2/2022 | ||
12/16/2022 | ||
TABLE 2: | ||
DEPT | COST | |
154 | $ 10.00 | |
654 | $ 7.00 | |
102 | $ 14.00 | |
RESULT: | ||
DATE | DEPT | COST |
11/4/2022 | 154 | $ 10.00 |
11/4/2022 | 654 | $ 7.00 |
11/4/2022 | 102 | $ 14.00 |
11/18/2022 | 154 | $ 10.00 |
11/18/2022 | 654 | $ 7.00 |
11/18/2022 | 102 | $ 14.00 |
12/2/2022 | 154 | $ 10.00 |
12/2/2022 | 654 | $ 7.00 |
12/2/2022 | 102 | $ 14.00 |
12/16/2022 | 154 | $ 10.00 |
12/16/2022 | 654 | $ 7.00 |
12/16/2022 | 102 | $ 14.00 |
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
Result table =
GENERATE( 'Table 1', 'Table 2' )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
Result table =
GENERATE( 'Table 1', 'Table 2' )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
110 | |
108 | |
88 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |