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

walt20221 — Tue, 16 May 2023 05:08:18 GMT

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.

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

Anonymous — Thu, 18 May 2023 02:21:30 GMT

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

topic Re: Substract 2 columns created through power bi matrix - comparing 2 weeks in DAX Commands and Tips

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

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