Solved: Sum of values from same column but based on multip...

ghanta · ‎12-16-2022

Hi,
I am trying to calculate TTM for count for each row in the following case and I am not sure what formula should I use

Count	YearQtr	YearQtr-1	YearQtr-2	YearQtr-3	TTM
100	2022-Q4	2022-Q3	2022-Q2	2022-Q1	1000
200	2022-Q3	2022-Q2	2022-Q1	2021-Q4	1400
300	2022-Q2	2022-Q1	2021-Q4	2021-Q3	1800
400	2022-Q1	2021-Q4	2021-Q3	2021-Q2
500	2021-Q4	2021-Q3	2021-Q2	2021-Q1
600	2021-Q3	2021-Q2	2021-Q1	2020-Q4

FreemanZ · ‎12-16-2022

Hi @ghanta

try to add a column with this:

TTM2 = 
VAR _a=[YearQtr]
VAR _b=[YearQtr-1]
VAR _c=[YearQtr-2]
VAR _d=[YearQtr-3]
RETURN
SUMX(
    FILTER(
        TableName,
        TableName[YearQtr] IN {_a, _b, _c, _d}
    ),
    TableName[Count]
)

i tried and it worked like this:

View solution in original post

FreemanZ · ‎12-16-2022

Hi @ghanta

try to add a column with this:

TTM2 = 
VAR _a=[YearQtr]
VAR _b=[YearQtr-1]
VAR _c=[YearQtr-2]
VAR _d=[YearQtr-3]
RETURN
SUMX(
    FILTER(
        TableName,
        TableName[YearQtr] IN {_a, _b, _c, _d}
    ),
    TableName[Count]
)

i tried and it worked like this: