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,
I'm trying to add a calculated column to one of my tables. I need this column to have a Voyage number to correspond to the voyage which the data was collected from.
I have a separte table with all the voyages (voyagedata) and the start and end date for each one. I was hoping there would be a way to use LOOKUPVALUE or something similar to search my 'voyagedata' table and assign a voyage to each observation in my other table.
So I need the function to look through each of the dates in this table ('eotrdata')
And give me which 'VoyageVessel' it relates to from this table ('voyagedata')
I was hoping it would be something simple like
LOOKUPVALUE(voyagedata[VoyageVessel]....)
But I'm coming from using R so I'm struggling with how these fucntions work, and I haven't seen any good tutorial for this specific issue.
Any help would be greatly appreciated 🙂
Solved! Go to Solution.
Hi @Spatch990,
Please create a calculated table:
New Table = FILTER ( CROSSJOIN ( eotrdata, voyagedata ), eotrdata[Observation Date] >= voyagedata[Start Date] && eotrdata[Observation Date] <= voyagedata[End Date] && eotrdata[Vessel] = voyagedata[VesselName] )
Regards,
Yuliana Gu
Hi @Spatch990,
Please create a calculated table:
New Table = FILTER ( CROSSJOIN ( eotrdata, voyagedata ), eotrdata[Observation Date] >= voyagedata[Start Date] && eotrdata[Observation Date] <= voyagedata[End Date] && eotrdata[Vessel] = voyagedata[VesselName] )
Regards,
Yuliana Gu
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |