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.
Hello,
I'm in stuck with my problem. Let's say I have 2 tables: Quotes and Shipments. My goal is to transfer QuoteID from Quotes table into Shipments table if such conditions are met:
Condintion = Condition
Departure is between StartDate and ExpiryDate
please see my file via this link
Solved! Go to Solution.
Hi @Anonymous,
You could try this:
Quote ID = CALCULATE ( FIRSTNONBLANK ( Quotes[Quote ID], 1 ), FILTER ( Quotes, Quotes[Condition] = EARLIER ( Shipments[Condition] ) && EARLIER ( Shipments[Departure] ) >= Quotes[StartDate] && EARLIER ( Shipments[Departure] ) <= Quotes[ExpiryDate] ) )
Best regards,
Yuliana Gu
Hi @Anonymous,
You could try this:
Quote ID = CALCULATE ( FIRSTNONBLANK ( Quotes[Quote ID], 1 ), FILTER ( Quotes, Quotes[Condition] = EARLIER ( Shipments[Condition] ) && EARLIER ( Shipments[Departure] ) >= Quotes[StartDate] && EARLIER ( Shipments[Departure] ) <= Quotes[ExpiryDate] ) )
Best 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 |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |