Forum Discussion
netanel
Post Prodigy
4 years agoConnecting 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
mh2587
Super User
4 years agoDaily AVG =
CALCULATE([Net USD average per Day], 'Revenues DB'[GL] IN { "InApp", "RV" })
Try this hope it works
Try this hope it works