Help on DAX formula for totals

[pbuzic]

Hi everyone,

please I need help for simple DAX formula to get new column (Totals) on right side where i could have sum of every change between vendors and customer by date. Example with new Totals is picture:

Power query from Vendor table:

Date | Vendor_LCY | Description

Power query from Customer table:

Date | Customer_LCY| Description

[Anonymous]

What's stopping you doing Sum(Vendor_LCY) + SUM(Customer_LCY) in a measure?

[v-jingzhang · Accepted solution]

Hi @pbuzic 

Do you have a Date table in the model? If so, you can create the following measure and add it to the table visual. 

Totals =
VAR __curDate = MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Vendor'[Vendor_LCY] ),
        ALL ( 'Date' ),
        'Date'[Date] <= __curDate
    )
        + CALCULATE (
            SUM ( 'Customer'[Customer_LCY] ),
            ALL ( 'Date' ),
            'Date'[Date] <= __curDate
        )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.