Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Substract same figures from each category

Hello,   If possible maybe someone can support with a solution, I will try to describe my situation: I have a growing database, each month a new version is uploaded:   Customer Planned Vol  ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Create two measures using dax as below:

    Latest actuals = 
VAR max_date =
    CALCULATE(MAX( 'Overview'[Source] ), ALL(Overview))
RETURN
    CALCULATE (
        MAX( 'Overview'[Actual volumes] ),
        FILTER ( ALLEXCEPT('Overview', Overview[Customer]), 'Overview'[Source] = max_date )
    )

Result = 
MAX(Overview[Planned Vol ]) - [Latest actuals]

    The result is like below:
     

     

    You can also refer to the attached pbix file.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

It looks like you've already solved the hard part.  Why doesn't this work with the two measures you already have?

 

Difference = [Planned Volume] - [Latest Actual Vol]

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello

I tried and it's just subtracting the figures from the March version.

To my extent I identify the actual figures for Daimler 40 / VW 30 delays, plese find example with my current status

pb.jpg

I want to subtract the March values from each source category.