topic Re: Combining measures from different tables in DAX Commands and Tips

Combining measures from different tables

Palikaros — Fri, 25 Nov 2022 13:37:41 GMT

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.

Re: Combining measures from different tables

amitchandak — Fri, 25 Nov 2022 16:20:24 GMT

Palikaros , Not very clear, but you can combine measure(add two measures) across common dimensions

= [Measure1] + [Measure2]

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

Re: Combining measures from different tables

Palikaros — Mon, 28 Nov 2022 14:07:10 GMT

Thanks amitchandak , it worked 🙂