Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago
Solved

Connecting formulas

Hi All!   I need help connecting the next two formulas to one formula   Daily AVG for InApp = CALCULATE([Net USD average per Day], 'Revenues DB'[GL] IN { "InApp" })   Daily AVG for RV = ...
  • Pragati11's avatar
    Pragati11
    4 years ago

    HI netanel ,

     

    I don't have anything to test the formula, so just wrote it based on my best judgement looking at your description.

    What error the formula is displaying?

    I am assuming you are creating a measure.

    Add more details as I can't help you to troubleshoot this way.

     

    See if this works:

    Net USD average per Day for InApp or RV =
    CALCULATE(
             [Net USD average per Day), 
             'Revenues DB'[GL] = "InApp" || 'Revenues DB'[GL] = "RV"
             )

     

    Thanks,

    Pragati

  • DimaMD's avatar
    DimaMD
    4 years ago

    netanel 
    Remove ")" before the comma 🙂

     

     

     

    CALCULATE(
             [Net USD average per Day], 
             'Revenues DB'[GL] = "InApp" || 'Revenues DB'[GL] = "RV"
             )