Forum Discussion
christinas
Helper I
7 months agoSubtracting 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.
christinas
Helper I
7 months agoThank you, ryan_mayu . I think that may work.
ryan_mayu
Super User
7 months agoyou are welcome