Forum Discussion

Helper I

7 months ago

Solved

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...

Need Help

ryan_mayu
7 months ago
christinas

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.

ryan_mayu

Super User

7 months ago

christinas

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.