Substract 2 columns created through power bi matrix - comparing 2 weeks

[walt20221]

Hello team, I am just starting with Power BI and I know this is not something new for you but I got some issues trying to acomplish this task.

I have a matrix visualization in power bi where I want to present open balance for customers comparing 2 weeks and at the end be able to see the substraction between the weeks per customer.

This is my visual:

I did create a measure, however the measure is summing the values instead of applying substraction.

here is the measure that I am using:

Difference11 =

VAR thisweeknumber =

    MIN ('Calendar'[Week No])

VAR thisAmt =

    SUM (Sheet1[Amount Due Original])

var lastsweeknumber=CALCULATE(MAX('Calendar'[Week No]),FILTER(ALLSELECTED('Calendar'),'Calendar'[Week No]< MAX('Calendar'[Week No])))

VAR lastAmt =

    CALCULATE (

        SUM (Sheet1[Amount Due Original]),

        'Calendar'[Week No] = lastsweeknumber

    )

RETURN

thisAmt  - lastAmt

Please will be great if you can give me a light on this. Thank you so much.

[v-binbinyu-msft]

Hi @walt20221 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu