Forum Discussion
Solved
Calculation using 2 data cards %
Hi, Thank you in advance for helping out for the below. I have a results by year and I would like to calculate extrapolated rate for the current year using previous years average. Data is as follow...
Hi,
These measures work
Average win % from 2017 - 2021 = AVERAGEX(filter(summarize(VALUES('Table'[Year]),'Table'[Year],"ABCD",[Sum_Win],"EFGH",[Sum_Opps]),'Table'[Year]>=2017&&'Table'[Year]<=2021),DIVIDE([ABCD],[EFGH]))Win % in 2022 = AVERAGEX(filter(summarize(VALUES('Table'[Year]),'Table'[Year],"ABCD",[Sum_Win],"EFGH",[Sum_Opps]),'Table'[Year]=2022),DIVIDE([ABCD],[EFGH]))Measure = DIVIDE([Win % in 2022],[Average win % from 2017 - 2021])Hope this helps.
I have helped you enough on this. I rewrote all formulas in the file which i shared with you today. Looks like tyou have not even looked at that file. Someone else will help you
Thank you, Ashish. Thank you so much for your continuous help on this. Actually, my requirement is to calculate win rates and extrapolated rates for each quarter and check for the current year's quarter. I am able to do all the calculations with your support other than the multiplication of current year quarter win rate with the extrapolated win rate of the previous quarter. Requirement to calculate D*C = 68.9%
A.
B.
C.
D.