Forum Discussion
Dora
Helper I
Helper IHow to get previous value for month filter
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 Mon...
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))
Greg_Deckler
Community Champion
Community ChampionPerhaps 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))
DoraHelper I
Helper IThank You ,It Worked.
Best Regards,
Dora