Comparing Rows in Power Query Part 1
It is straightforward to compare values between each row in an Excel table and the next row.
Content Type: Blog Post
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?
Using Dax to create a KPI
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper.
Dax: Back to the basics
For me, whenever I am new to a concept, and I read a statement like the one above, I often say “Well that’s great, but just what does that mean?” I am a big believer in mental models or ways of visualizing the flow of execution.
Journey to P3: Krissy Dyess
Well, it looks like I’m up next to share my PowerPivot and P3 Adaptive story!
Power Query (M)agic – Nested Calculations in Power Query – Finance Application
One of the most powerful features (and there are lots) that I’ve found about Power Query is the ability to hold an entire table in a single cell.
Power Query (M)agic – Using Power Query to Transform and Combine Online StatsCan Data
Power Query (aka “Get and Transform” in Excel, aka the “Query Editor” in Power BI Desktop) is a powerful ETL tool, more powerful than you might expect from something native to Excel (also a native part of the free software Power BI Desktop).
Adding Visual Flair In Power BI With Background Colors
Hello P3 Adaptive Nation! Today’s “post” is going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots.
PowerQuery (M)agic: Combine M Functions and Formulas In Custom Columns
Humans like turning a few things into many things. Investing $1 to get $10 . . . growing saplings into oaks . . . taking two rabbits and creating a fluffle.
Conditional Formatting Using Text In Power BI Desktop
Hello P3 Adaptive Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots
Journey to P3 Adaptive : Narayana Windenberger
When was the last time you had an interview with the president of the company and he was wearing shorts and a t-shirt while you were decked out in a suit?