Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
3 years ago

Dax formule Total

Hi, 

 

I have created a matrix with various dax formulas (total, total -1 month, verschil), now I want to add a new formula to add positive amounts (POS) (based on difference) and negative amounts (NEG). Like the attached example. Only the DAX I created shows the yellow shaded amounts. The total is not properly included with POS and NEG, here it is looked at total.  I briefly recreated the matrix in excel to clarify my question.

Thanks!

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional

    Hey Moniek ,

     

    that's kind of difficult to say with an Excel screenshot and not details about the formulas.

    Can you provide a sample files or at least an example in Power BI?

     

    Best regards

    Denis

    • Moniek's avatar
      Moniek
      Icon for Resolver I rankResolver I

      Thank you for the response. Unfortunately I can't upload files. hopefully you can do something with the this screenshot.