Forum Discussion
Solved
How 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))
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))
Thank You ,It Worked.
Best Regards,
Dora
