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:


enter image description here

I would like to add a new calculated column and be able to display the following:

Table2. enter image description here

How could I do this? I am struggling to write the correct DAX query. Would appreciate any help. Thanks in advance,

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.