Forum Discussion
Previous Value on the same table
Hi i have this table : I used this formula to take the previous row previous = CALCULATE( SUM('Fact Risk Decision Flow'[grd_granted_amount_value_euro]); TOPN(1; FILTER( ALLSELEC...
Thanks for your reply but it's not exactly the solution that i need 😉
Indeed the period could be 2 years ago and not only -1.
I'm using SSAS 2016 so, REMOVEFILTERS and SELECTEDVALUES not works but i replace it with equivalent formula.
Thank you by advance
Hi PBI-IK.
if you want to get the solution you're after, you have to do a bit more upfront work. Please define your problem more clearly and show all the involved structures.
Best
D
if you want to get the solution you're after, you have to do a bit more upfront work. Please define your problem more clearly and show all the involved structures.
Best
D