I am new in SSAS tabular model and I am working on a project where one of the requests is to calculate rent for the previous months.
So my input data look like this:
I would like to add a new calculated column and be able to display the following:
How could I do this? I am struggling to write the correct DAX query. Would appreciate any help. Thanks in advance,