Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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