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.
Drill-Through to Subtotal’s Details in Power BI
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
What are translation tables in Power Query’s Fuzzy Match and why would we need them?
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.
