add conditional column

[marcobi]

Hello!

I have this table. Relevant for us are the columns [Nummer], [Saldo] and [Date].

For each Month there is 1 row in [nummer]. I just want to add a column [saldo previous month] where it takes the corresponding value from [saldo] from the same [nummer] from last month.

I've made an example in the picture below. There is also a pbix file here: https://1drv.ms/u/s!ArzXZfC_jkl3gch6T5Ssb4Rjue6Cww?e=oSyWho

Can somebody help me to add this conditional column? I really don't get it how to code this column. 

Thank you!

Marco

[marcobi]

thank you very much!

[mangaus1111 · Accepted solution]

Hi @marcobi ,

see my pbi file . I hope it works for you.

https://1drv.ms/u/s!Aj45jbu0mDVJi1fpb7mb9D8yvJKS?e=xIWcIp

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.