Forum Discussion

alhyde's avatar
alhyde
New Member
9 years ago
Solved

DAX Formula for subtracting columns?

I am trying to caluculate current year revenue(column C) by subtracting prior revenue (column B) from revenue to date (column A).  In theory, the formula would be A - B = C.  Would I use some form of...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    alhyde

     

    Try with:

     

    C=Calculate (Sum(Table[A]))-Calculate (Sum(Table[B]))

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

alhyde

 

Try with:

 

C=Calculate (Sum(Table[A]))-Calculate (Sum(Table[B]))

  • alhyde's avatar
    alhyde
    New Member
    9 years ago

    Vvelarde thanks for the solution!  It worked!

  • JRadical's avatar
    JRadical
    New Member
    9 years ago

    What if one of these tables is a measure?

     

    Can you do C = A - B if B is [B]?