Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
Below is my model:
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
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
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
hope this message finds you well. Just wondering if you had the chance to look at the file I sent?
Thanks,
Wes
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |