How to get previous value for month filter

[Dora]

Hi All,

I get previous month Liabilty measure correctly as follows. But when I am using Month filter it gives a zero  value for each month.

How can I fix this error.

Before Selecting the Month Slicer:-

After Selecting the Month Slicer:-

Measure that used:-

Prev Month Liability =
VAR Currentindex=SELECTEDVALUE(GL_LEDGER_ACCESS[index 2])

RETURN
CALCULATE([Liability This Month],
FILTER(ALLSELECTED(GL_LEDGER_ACCESS),GL_LEDGER_ACCESS[index 2]= Currentindex-1))

(I do not use "date table" since my data set have random data with month not with date so I make a new index column for each month I have)

Please Help ,

Best Regards

Dora

[Greg_Deckler · Accepted solution]

Perhaps try:

Prev Month Liability =
VAR Currentindex=SELECTEDVALUE(GL_LEDGER_ACCESS[index 2])
RETURN
CALCULATE([Liability This Month],
FILTER(ALL(GL_LEDGER_ACCESS),GL_LEDGER_ACCESS[index 2]= Currentindex-1))

[Dora]

Thank You ,It Worked.

Best Regards,

Dora