Forum Discussion
GracieLeeMonroe
4 years agoFrequent Visitor
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...
GracieLeeMonroe
4 years agoFrequent Visitor
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
4 years agoCommunity Support
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