Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @Anonymous,
Please refer to below measure formulas:
Total = SUM('Yearly amount'[Amount]) Total N-1 by quarter = CALCULATE ( [Total], FILTER ( ALLEXCEPT ( 'Yearly amount', 'Yearly amount'[QuarterName] ), 'Yearly amount'[Year] = MAX ( 'Yearly amount'[Year] ) - 1 ) ) YOY = IF ( MAX ( 'Yearly amount'[Year] ) = CALCULATE ( MIN ( 'Yearly amount'[Year] ), ALL ( 'Yearly amount' ) ), BLANK (), DIVIDE ( [Total], [Total N-1 by quarter], BLANK () ) - 1 )
Best regards,
Yuliana Gu
Hi @Anonymous,
Please refer to below measure formulas:
Total = SUM('Yearly amount'[Amount]) Total N-1 by quarter = CALCULATE ( [Total], FILTER ( ALLEXCEPT ( 'Yearly amount', 'Yearly amount'[QuarterName] ), 'Yearly amount'[Year] = MAX ( 'Yearly amount'[Year] ) - 1 ) ) YOY = IF ( MAX ( 'Yearly amount'[Year] ) = CALCULATE ( MIN ( 'Yearly amount'[Year] ), ALL ( 'Yearly amount' ) ), BLANK (), DIVIDE ( [Total], [Total N-1 by quarter], BLANK () ) - 1 )
Best regards,
Yuliana Gu
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |