Comparing Rows in Power Query Part 2
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 […]
Search Results for: https://ww
So, You’re Getting a Data Warehouse for Power BI…
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.
Comparing Rows in Power Query Part 1
It is straightforward to compare values between each row in an Excel table and the next row.
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.
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?
Navigating DAX Function Types: A list of DAX Scalar and Table functions
Let’s start off today’s post with a pop quiz. Once you’ve answered, click here to see the poll results, and then scroll down to see the correct answer
Power Query (M)agic: Scraping ads.txt info from multiple sites
I worked most of my career as an actuary at various insurance companies. Most of the time they had systems that were built before I was born, so I spent a good portion of time getting and transforming (see what I just did?) data into a format ready for analysis.
Disconnected Slicers With DAX Variables & SELECTEDVALUES
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.