https://docs.google.com/spreadsheets/d/1qnh07BRHlbXaGnLkgahf95uXpkDlXgUq5oKS866OMoo/edit?usp=sharing Hi all, Please help i have attached a link below for the excel sheet i need help with creating a measure that will calculate the columns that are highlighted in blue in the attached excel link Thanks

Hi Xirhandziwa, You can try to use the following measure formulas to achieve your requirement: mat 2021 = VAR currDate = MAX ( 'Table'[Date] ) RETURN CALCULATE ( SUM ( 'Table'[2020/2021] ), FILTER ( ALLSELECTED ( 'Table' ), [Date] > currDate ) ) + CALCULATE ( SUM ( 'Table'[2021/2022] ), FILTER ( ALLSELECTED ( 'Table' ), [Date] <= currDate ) ) mat 2022 = VAR currDate = MAX ( 'Table'[Date] ) RETURN CALCULATE ( SUM ( 'Table'[2021/2022] ), FILTER ( ALLSELECTED ( 'Table' ), [Date] > currDate ) ) + CALCULATE ( SUM ( 'Table'[2022/2023] ), FILTER ( ALLSELECTED ( 'Table' ), [Date] <= currDate ) ) diff = [mat 2022]-[mat 2021] Regards, Xiaoxin Sheng

Power BI measure | Microsoft Fabric Community

Forum Discussion

Related content

power bi measure

POWER BI DAX MEASURE

Measure required in Power BI matrix

Power BI Theme - Including Common Measures

Power Apps for Power Bi