Forum Discussion

GracieLeeMonroe's avatar
GracieLeeMonroe
Frequent Visitor
4 years ago

Lookup does not work

All I am trying to get a date by certain criterias (serial no. and Product type) since I need to calculate the difference between those dates in month in order to calculate the correct quantity of p...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, GracieLeeMonroe 

 

I checked your measure, trying to find the logic, I found that your code is very verbose, and the two codes of lookupvalue are indeed wrong, but I don't know what you want.

So I need a complete and valid sample along with your calculation logic and expected results to help you modify measure. If you can provide, I'll help you streamline your code and modify it correctly.

 

Best Regards,
Community Support Team _ Janey

  • GracieLeeMonroe's avatar
    GracieLeeMonroe
    Frequent Visitor
    4 years ago

    Hi v-janeyg-msft 

    thanks for your answer. I did not ignore you but was working on my huge excel files last week which actually are to be replaced by PowerBI. Regarding the sample, what exactly do you need? An extract from PowerBI in xls-format? I would need to remove/replace confidential data of course.....

    Thanks!

    Regards

    Angie

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      Hi, GracieLeeMonroe 

       

      Check this:

      How to Get Your Question Answered Quickly - Microsoft Power BI Community

       

      If you don't give the complete dummy data, it's hard for me to judge the logic of your measure.

      Like what's FOT_Adjusted?

      And your code is too verbose, I don't need to read this, I just need you to tell me the complete calculation logic, so I can create a new for you.

       

      Best Regards,
      Community Support Team _ Janey