Forum Discussion
Solved
Combining measures from different tables
Hello,
I have one table named CV_BPC_BRIDGES_R4_ACT where all actual financial data are flowing, from which i created a measure "
PY Actual Net Sales" which calculates Prior year actual net sales.
I have also one more table CV_BPC_BRIDGES_R4_ACT (since data are flowing from different system) for all Current year + Forecast financial data, where i have created a measure "CY Actual Net Sales".
Is it possible to create a measure that will combine these two measures? Of course, it should be dynamic, as the initial measures based on the user`s selection for quarter & country (this is managed through slicers)
Thank you in advance.
Palikaros , Not very clear, but you can combine measure(add two measures) across common dimensions
= [Measure1] + [Measure2]
2 Replies
Palikaros , Not very clear, but you can combine measure(add two measures) across common dimensions
= [Measure1] + [Measure2]
Thanks amitchandak , it worked 🙂
