Alernative to lookup value

[ansar]

Hi ,

Need a help to create a measure to convert values of Prov LC (measure) without using LOOKUPVALUE ,

Based on Data[Curr] it has to fetch rates from FX Rates[Rate] and divide.

Regards,

Ansar.

[v-chenwuz-msft · Accepted solution]

Hi ansar,

You can try this measure.

Measure = SUMX('Data',RELATED('FX Rate'[Rate])*[Prov LC])

Or

You can create a column

column = RELATED('FX Rate'[Rate])*'Data'[LC amnt]

then change the measure Prov LC

Prov LC = CALCULATE(SUM(Data[column])*-1,'Data'[Type]="BF")

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

@ansar 

Because the tables are joined you can use the RELATED function to retreive the rate.

https://docs.microsoft.com/en-us/dax/related-function-dax

[ansar]

Thanks @jdbuchanan71  for the support.