Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Need to calculate Growth from Prior period and display in Matrix table.
Sliceres: Scenario (Actual, budget, Fore cast), Period, Year.
If i select scenario as actual, below formula should work, now it's working fine
Growth from Prior period = ((actual Amount - Prior period Actual Amount) / Prior period Actual Amount),
If i select scenario as Budget, below formula should work,
Growth from Prior period = ((Budget Amount - Prior period Actual Amount) / Prior period Actual Amount)
when i chose Scenario as budget , Prior period Actual Amount is zero, because of Scenario filter applied as bidget.
So can anyone help me my formula should work , when i chose scenario as budget, my measure should pick 'Prior period Actual Amount' based on period and Year slicer.
Can anyone help me here my measure should pick up period, year slicer and exclude scenario slicer .
Thanks,
Hello @VikramAdi ,
Can you please try using ALL instead of REMOVEFILTERS and using ALL is bit different than REMOVEFILTERS so go through it and see if your requirement is fulfilled or not.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |