Forum Discussion
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...
I prepared the excel sample extract:
I know you do prefer PBIX, but the source file is on sharepoint and I cannot change that data of course.
I did highlight the calculated columns, the column I try to calculate is AU. We can do a screen sharing as well if necessary.
Regards
Angie
sorry, my bad. I changed the settings plus imported the excel into a sample PowerBI file:
https://drive.google.com/file/d/1soJ0IG0gnLW_cndyOPc6HfyehB0DQ-9Y/view?usp=sharing
Just let me know if this is now working.
Thanks.
Regards
Angie
Hi, GracieLeeMonroe
Can you tell me for this formula what do you want to get? Your measure is too messy and I can't see a complete logic from your description, It's hard for me to get started without logic.
