Forum Discussion

Neilos's avatar
Neilos
New Member
10 months ago
Solved

Check itemcode from SQL query against a list of codes from an excel import

Hi All,   I have a query loaded directly from an SQL database into PowerBI and I also have a simple one column list of codes loaded from an excel file that will be updated regularly. I need to che...
Need Help
Tutorial Requests
  • v-achippa's avatar
    v-achippa
    10 months ago

    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

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
10 months ago

Hi Neilos,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
10 months ago

Hi @Neilos,

 

We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa