I watched a video from Guy in a Cube’s Patrick featuring Marco Russo where they walked through an example using a technique to debug DAX measures using VAR/RETURN – I loved this! https://www.youtube.com/watch?v=9SV2VnYbgg4 The video made me recall another Blog…
This is a quick tip on 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. For…
The Microsoft Data Platform (and probably any BI tool) and FP&A seem to have at least one thing in common: it’s hard to find qualified people. I hear it all the time. I don’t think I consciously concluded that I…
We are back to finish our discussion on the visualizations for Comparing Rows in Power Query! How to visualize the prices and daily changes The two metals have very different price ranges so it is difficult to see them in…
Data Warehouses: What Do I Know? Well, I'm no expert. I learned Power Pivot and Power BI through Excel. What I know is from helping to build a SQL data warehouse. That is, I've worked with a data warehouse pro.…
Hello P3 Blog readers! Well, it’s been a while since I’ve blogged – what can I say, it was a busy summer! BOO you say?! You need your Cat Meme fix!?! Well, let’s see if I can DO something about…
It is straightforward to compare values between each row in an Excel table and the next row. You can create a calculated column in a table and reference values in other columns in the same row by name and cells…
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. While indirect method cash flow statements can be prepared easily from P&L…
I don’t like to answer these or similar questions: “What is your career path?” “Where do you see yourself in five years?” “…in ten years…?” I generally find it hard to answer questions about what I do, because my…
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. Each subsidiary can also have one or multiple subsidiaries beneath it.…