Forum Discussion

ansar's avatar
ansar
Icon for Helper II rankHelper II
5 years ago
Solved

Alernative to lookup value

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.       ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    5 years ago

    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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
5 years ago

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.