LOOKUPVALUE in PowerQuery
I love LOOKUPVALUE. It’s a great DAX function. However, sometimes, it’s better for the column to be looked up in Power Query. To bring in a column from another table, Merge your lookup table with your main table on the common key. Here’s an example where I bring in the State Name into a table.…
Read more
Recent Comments