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
Kindly support on the above query. I am thankful in advance for the support