Forum Discussion
christinas
7 months agoHelper I
Subtracting from two difference tables
Hello. Thank you for your help in advance. I have two tables with the same columns on it for both; one is data for 2024 and one is for 2025. I am trying to find what information has changed between y...
- 7 months ago
here is suggestion:
1. I think you need to create some dim tables (e.g. job family name table ) and connect dim table to these two fact tables. Then in the matrix visual, the job family info should comes from the dim table.
2. Since you mentioned the tables with same columns. You can append tables in the power query
https://learn.microsoft.com/bs-latn-ba/power-query/append-queries?wt.mc_id=DP-MVP-5004616
or do it by using DAX
https://learn.microsoft.com/en-us/dax/union-function-dax?wt.mc_id=DP-MVP-5004616
If these two approahes still does not work for you, pls provide some sample data and expected output.
Ashish_Mathur
7 months agoSuper User
Hi,
Share the download link of the PBI file or share some dummy data to work with.