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
Hi,
Share the download link of your PBI file. Ensure that you already have your measures for A and B there.
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.
Dear Ashish, Thank you for the previous measures and it is useful. Now, again thank you in advance for helping me out with another measure.
With the same example below, I would like to get the extrapolated rate i.e.,
Win % in 2022(57.01%)*Measure (91.95%) = 52.42%
You are welcome.
Just multiply the 2 measures.