Forum Discussion
netanel
4 years agoPost Prodigy
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 = ...
- 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
Pragati11
4 years agoSuper User
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