Atlanta Business Intelligence Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Which option to use Merge Query or LOOKUPVALUE?

  • 1.  Which option to use Merge Query or LOOKUPVALUE?

    Posted Oct 27, 2021 01:50 PM
    Hi,
        I'am new to PBI. I have a report wherein in need to lookup value's from another table based on a common criteria in both tables. Similar to vlookup in excel. Have around 100k to 200k lines in both tables . So which option is best to use in my scenario. Merge Query or LOOKUPVALUE?.





    Regards
    Sarun Raroth

    ------------------------------
    Sarun Raroth
    BI Developer
    ------------------------------