Forum Discussion

lvdnest3866's avatar
lvdnest3866
Regular Visitor
8 years ago
Solved

Lookup Rate Code in RateTable and return the Amount for that Ratecode to the Fact Table.

Hi there,   Please help. I have the Fact table (PRMSTable) and the lookup table (Rate code extract).   In the PRMStable I have 4 different columns each with their own Rate codes. ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi lvdnest3866，

     

    There is a little complex for your case.

     

    Based on your title, it seems that you're confused of using lookupvalue  function.

     

    You could have a view of this video which introduce the scenarios about LookupValue.

     

    If you need further, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    I would appreciate it if you could show your final desired output.

     

    Best Regards，

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi lvdnest3866，

 

There is a little complex for your case.

 

Based on your title, it seems that you're confused of using lookupvalue  function.

 

You could have a view of this video which introduce the scenarios about LookupValue.

 

If you need further, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

I would appreciate it if you could show your final desired output.

 

Best Regards，

Cherry

  • lvdnest3866's avatar
    lvdnest3866
    Regular Visitor
    8 years ago

    Hello Cherry.

     

    Thank you so much. That was exactly what i needed. It was very easy to do.

    I just did not know the DAX function to use, but now i will abuse it. 

     

    I will upload my results soon.

     

    Regards.