Power BI Brain Candy: Value Above Replacement
In today’s article, I’m aiming to achieve three overlapping goals:
Category: Self-Service Data Tools
How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?
Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one.
Export Power BI Data with Date Range in Title
In Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a […]
Power Query (M)agic: Parameters for Dataflows!
I’ll get to parameters for dataflows in a bit. To begin, let’s talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service.
PowerQuery(M)agic: Conditional Joins using Table.SelectRows()
In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page.
Finding the Flow: A Beginner’s Guide to Microsoft Flow
For the new year, I have a question for you: What do you think of when you hear the word “Flow”?
Setting a Default Slicer Selection
I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports
Reducing DSO using Power Pivot
One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.
Automated Testing With Power Query
I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality.
Power Pivot Cracks Direct Method Cash Flow Conundrum
Many accountants consider that cash flow statements are the most important indicator of a company’s performance, as they do not involve estimates or judgments of the preparers.
Using Dax To Handle Multiple Parent Hierarchies
A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries.
Automated Testing Using Dax for Power BI
How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right?