Forum Discussion
Calculation using 2 data cards %
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
I get the correct answer - see Measure 2. Download the PBI file from here.
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.
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
Sorry for the confusion.
Please find the .pbix file (Ref Table (2)) and request you to help. Thank you as always.
https://drive.google.com/file/d/1F5z4vESS1uLquMzqi6Pr591lu3aQYjag/view?usp=sharing