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 Everyone,
I need to retrieve Rate.Value only where Rate.Type = 20 and input it to column in the ServiceTicketline table. Using Serviceticketline.ServiceRateTable and Rate.ServiceRateTable as the join.
Solved! Go to Solution.
Hi @Anonymous,
The formula could be like below. Please refer to Lookupvalue.
lookupColumn = LOOKUPVALUE ( 'Rate'[Value], 'Rate'[RateType], 20, 'Rate'[ServiceRatetable], [ServiceRateTable] )
If this can't achieve your goal, please provide a sample.
Best Regards,
Dale
I am looking to only pull back values where rate type is "20"
Whats the best way to do this?
My initial thought was a function like
Lookupvalue(
'Rate'[Value]where {ratetype}=20,
'Rate'[ServiceRatetable],
'Serviceticketline'[ServiceRateTable])
this function does not work.
Hi @Anonymous,
The formula could be like below. Please refer to Lookupvalue.
lookupColumn = LOOKUPVALUE ( 'Rate'[Value], 'Rate'[RateType], 20, 'Rate'[ServiceRatetable], [ServiceRateTable] )
If this can't achieve your goal, please provide a sample.
Best Regards,
Dale
Instead of mentioning values to filter, how can I write this to ignore certain values or blanks?
WOW! it worked!
Thank you
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |