Forum Discussion
Check itemcode from SQL query against a list of codes from an excel import
Hi Neilos,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Tahreem24 for the prompt response.
Thank you for sharing the detailed explanation. Based on your requirement, the best approach is to keep the Excel list as a separate table in your model rather than merging it into the Sql table.
Create a relationship between the ItemCode columns in both tables like List[ItemCode] --> SQL[ItemCode] and then use DAX measures to calculate the in list and not in list totals dynamically.
This will give you exactly the Utopia layout you described, with correct totals and automatic updates when your excel list changes.
Thanks and regards,
Anjan Kumar Chippa
Tahreem24 Thanks for the quick response.
I would have included an screenshot of the data as that would explain better, but it has sensetive info included so chose not to.
I'll explain the data as I have it.
SQL consists of;
Payment Number
Date
Invoice Number
ItemCode
Description
Quantity
Price
Total
There are 6000+ lines.
Excel is a very simple single column of ItemCodes.
I need to check the item codes in SQL data to see if they are listed in the excel data.
Then I need to create tables of what is in the list and what isn't.
Hope that explains what I've asked better.
If a sample is needed I can put a file together with dummy data.
Thank you.
