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]))

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi alhyde,

 

What is your current situation?

The formula provided by Vvelarde should have the same results with the formula below:

C = A - B

 

Adding a blog for reference:

Understanding Context Transition

If that formula didn't meet your requirements, then please post back.

Regards