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 Guys,
I am trying to solve this data model. How I will link my dimesion tables to this ..
ANy suggestion please.
Thanks in advance.
Solved! Go to Solution.
Maybe you can try power query editor -> Merge queries, please reference the following article. This will let you know how to merge tables to one table.
In your case, first copy the ExpenseTable so that if there are any errors you can have a backup, and rename it.
Then use the merger queries under the home tab set as the following show:
Click ok and expend the new column, select Actual:
You will get the result you want. i put pbix file in the end.
If you need to do the calculations in the desktop, I have also shown them in the pbix file. If I misunderstood you please let me know.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maybe you can try power query editor -> Merge queries, please reference the following article. This will let you know how to merge tables to one table.
In your case, first copy the ExpenseTable so that if there are any errors you can have a backup, and rename it.
Then use the merger queries under the home tab set as the following show:
Click ok and expend the new column, select Actual:
You will get the result you want. i put pbix file in the end.
If you need to do the calculations in the desktop, I have also shown them in the pbix file. If I misunderstood you please let me know.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ImranAslamEMH ,
You can create relationship among your tables on COSTCODE column.
Thanks,
Pragati
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |