Forum Discussion
Helper IVHow to get Column from other transaction table
Dear All,
I have the below scenario:
data Model as below:
I have two transaction tables (fact) as Fact G and Fact P.
Now my requirement is to create analysis as
In the model Supplier and Date are the confirmed Dimensions.
from Fact G:-
Quantity and Cost by Region By Type and same from Fact P as well " Quantity, cost By Region By Type".
Could someone please help to archive it by writing DAX
Help would be appreciated.
Regards,
Sonu
4 Replies
CNENFRNLCommunity Champion
Hi, sonuojha1 , by intuition, I think Expanded Table might come to your rescue; I tried with your data model but with more mockup data. It seems to work to me. You might want to see the attached file for more details.
- amitchandak
Super User
sonuojha1 , take type (fact G) , from common take supplier, date, and Qty and Cost as measures from both table and try.
I doubt you can get a correct answer for that.
- sonuojha1
amitchandakNo, I don't want to combine all in single report. Just want to create a measure so that I can use that in different visuals.
- sonuojha1
Is there any way to get Type column by using RELATED. I understand related works with direct joined table/ or by using LOOKUPVALUE. Kindly suggest and help.
