Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
wes-shen-poal
Helper III
Helper III

Calculate Column based on columns from multiple tables

Hi there,

 

Below is my model:

 

ERD.PNG

 

I would like to calculate a column in the 'inv_unit' table, that gives me the 'srv_event'[placed_time] for each gkey (or row) in the 'inv_unit' table.

 

but because there are multiple 'srv_event'[placed_time] for a given 'inv_unit'[gkey], the criterion for choosing the correct 'srv_event'[placed_time] is where 'srv_event_types'[id]="UNIT_LOAD"

 

Please can someone kindly help me by telling me what my calculated column formula in 'inv_unit' data table should look like to achieve this?

 

Thanks in advance for your help


Wes

3 REPLIES 3
v-caliao-msft
Employee
Employee

@wes-shen-poal,

 

We can use FILTER and RELATED function to get value from another table. If you could provide us some sample data, we can try to figure out the detail formula.

https://msdn.microsoft.com/en-us/library/ee634202.aspx

 

Regards,

Charlie Liao

hi @v-caliao-msft

 

Thanks for looking into this for me.

 

I've just sent you a private message with a link to the pbix file. I hope that's ok.

 

Thanks again in advance for your help.


Wes

hi @v-caliao-msft

 

hope this message finds you well. Just wondering if you had the chance to look at the file I sent?


Thanks,
Wes

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.