March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
I need help to plan a check between two numbers on different models.
I have one Sharepoint extraction with this data:
Year | Week | Data |
2021 | 1 | 25 |
2021 | 1 | 45 |
2021 | 3 | 70 |
2020 | 5 | 18 |
2020 | 5 | 15 |
Where by using a slicer I check Years/Week Data SUM.
I also have another Sharepoint data list like this:
Year | Week | Data |
2021 | 1 | 200 |
2021 | 2 | 150 |
2020 | 3 | 300 |
2021 | 4 | 270 |
2020 | 5 | 250 |
Is there a way to connect 2 models and have the difference between the SUM of the "Data" of the first Sharepoint list and the TOTAL of the single line by Year/Week on the second Sharepoint list?
Like:
200 - 25+45 (of the week 1 on year 2021) = 130
Thank you!
Solved! Go to Solution.
Hi, @ESS
To create Year-Week calculated column in two tables:
result:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @ESS
To create Year-Week calculated column in two tables:
result:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much 🙂
@ESS , Create a common table for year week nad join with both of them
New table= distinct(union(summarize(Table1, Table1[Year],Table1[week]),summarize(Table2, Table2[Year],Table2[week])))
Create a new column in all three tables
year week = [Year]*100 + [Week]
Join the new table with the other two and analyze it together
new measure = sum(Table1[data]) -sum(Table2[Date])
Thanks for the answer.
I didn't understand how it work. Distinct formula remove duplicates but on there is Week 30 in 2020 and also in 2021. I'm sorry but I wrote just 2021 in my example but I have few years on the table.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |