Hi there, welcome to my blog
As you can guess, I do data and I’m a proud dad, so the blog name is not a mystery 🙂 This is my project, with topics about data analytics, data visualization and business intelligence. Enjoy.
A friend asked me about a way to allow users to display line level information – what you normally do with a drillthrough page – however, not for a single line, but for all currently selected items in the table object, i.e. if you have a simple table, like the one below: How can we … Continue reading Drill-Through to Subtotal’s Details in Power BI
In Power Query, we have the option to use Fuzzy Match when merging tables. A little known feature are the Translation Tables which help in that process. Merging tables is relatively straightforward in Power Query – choose the left table, choose the right table, mark the columns for the merge to be made onto, choose … Continue reading What are translation tables in Power Query’s Fuzzy Match and why would we need them?
Follow My Blog
Get new content delivered directly to your inbox.