Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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))
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
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |