Blog

Minnesota State Employee Salary Search

Tool for searching Minnesota State Employee Salary data.

How To Export Matrix visual not in Tabular Form

I stumbled upon this post in the Power BI Community because a customer had the same request. When they exported out of the Matrix visual they were getting tabbed data. The csv file ends up being tabbed and the user wanted it to export just as it displayed in Power BI. My solution for the…
Read more

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