Forum Discussion

JeffreyBl's avatar
JeffreyBl
New Member
4 years ago
Solved

Calculate new column with WHERE function

Hi, I'm trying to create a new field via a new formula in which I use the WHERE function.   Billable uren = 'DEA-Amsterdam'[Totale uren] WHERE 'DEA-Amsterdam'[Omzetwaarde] > 0'   I want to cal...
Need Help
  • Thejeswar's avatar
    Thejeswar
    4 years ago

    Hi JeffreyBl ,

    You can use it like shown below

     

    Billable uren = CALCULATE(SUM('DEA-Amsterdam'[Totale uren] ),  'DEA-Amsterdam'[Omzetwaarde] > 0)

     

    Regards,

AntonioHR's avatar
AntonioHR
Helper I
4 years ago

Hello JeffreyBl 

 

This should work _

Billable uren = CALCULATE('DEA-Amsterdam'[Totale uren],'DEA-Amsterdam'[Omzetwaarde] > 0')