Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |