Forum Discussion
Measure to divide values from different size tables
Hi, I have two tables:
1.
and 2:
This is one table, just very big, and 2023 has 235 days, as well as 2024, 2025, etc.
I would like to have a measure to see % of a plan completed each year so I can later show it in a chart - For 235 days we make a sum of pcs, and this would for example be 600 000 for 2023, and then we divide it by the plan, so by 630 000 in 2023, 780 000 in 2024, etc.
My result should say:
2023: 95%
2024: 76%
etc.
Is there any way to make a measure that will easily allow me to put this in one chart? I would basically want to replace the below chart with one simple column with percentages per each year:
Thank you!
3 Replies
- NaveenGandhi
Memorable Member
- pal95
Helper III
Hi Naveen,
.csv is not supported, so please find the link attached https://wetransfer.com/downloads/099986e8556b5f78aed480c9fe75be8c20230607074840/0fd2d4a7d166ffa9e00e0c045f6ee8eb20230607074857/8be841
The second table is just the same as above, with 2 columns and 4 rows
Thank you- NaveenGandhi
Memorable Member