Forum Discussion
calculation
- Anonymous3 years ago
Hi achanikya ,
Assume that you have the table data as below screenshot, you can create a measure as below to get it. Please find the details in the attachment.
Percent = VAR _2021 = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Year] = 2021 ) VAR _2022 = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Year] = 2022 ) VAR _percent = IF ( ISBLANK ( _2021 ) || _2021 = 0, BLANK (), DIVIDE ( _2022 - _2021, _2021 ) ) RETURN IF ( ISINSCOPE ( 'Table'[Year] ), SUM ( 'Table'[Value] ), _percent )What your raw data looks like? Could you please provide some sample data(exclude sensitive data) and your final expected result? Do you want to get the difference percentage between current year and previous year? Thank you.
Best Regards
pls share the emai Id
Thanks
Chanikya A
Hi achanikya ,
Assume that you have the table data as below screenshot, you can create a measure as below to get it. Please find the details in the attachment.
Percent =
VAR _2021 =
CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Year] = 2021 )
VAR _2022 =
CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Year] = 2022 )
VAR _percent =
IF ( ISBLANK ( _2021 ) || _2021 = 0, BLANK (), DIVIDE ( _2022 - _2021, _2021 ) )
RETURN
IF (
ISINSCOPE ( 'Table'[Year] ),
SUM ( 'Table'[Value] ),
_percent
)
What your raw data looks like? Could you please provide some sample data(exclude sensitive data) and your final expected result? Do you want to get the difference percentage between current year and previous year? Thank you.
Best Regards
- achanikya3 years agoHelper I
Anonymous Hi thask for help