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.

 

 

 

 

 

Regards,

Ansar.

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.

3 Replies

  • 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.