Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi there.
The screen below shows 2 matrix (from 2 different tables). I would like to create a 3rd matrix (in the same format as the 1st 2 matrix) whereby I can show for each financial year, the difference between the approved amount and the committed amount.
Any suggestio would be much appreciated.
Thanks.
Solved! Go to Solution.
Hi@irisyeong
You can do these like me as below:
Step 1:
Create relationship between two table by year like this:
Measure = CALCULATE ( SUMX ( Table1, Table1[Qty] - CALCULATE ( SUMX ( RELATEDTABLE ( Table2 ), Table2[Qty] ), FILTER ( Table2, Table2[ComFS] = Table1[FundingSource] ) ) ) )
Best Regards,
Lin
Hi@irisyeong
You can do these like me as below:
Step 1:
Create relationship between two table by year like this:
Measure = CALCULATE ( SUMX ( Table1, Table1[Qty] - CALCULATE ( SUMX ( RELATEDTABLE ( Table2 ), Table2[Qty] ), FILTER ( Table2, Table2[ComFS] = Table1[FundingSource] ) ) ) )
Best Regards,
Lin
Thanks Lin. It worked. Much appreciated.
Hi,
I have something similiar. I want to show difference between this two table on a month with graphics preview.
Can you help me ?
In this case I want to show the diferene for each parameters graphically.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
94 | |
89 | |
32 | |
28 |