How to Get Power BI Service to Work for You
I’ve been using the Power BI Service (PBIS) daily for five months, and before that, I consulted on challenging DAX problems for over a year.
Category: Power BI
Power Query (M)agic: Dynamically remove leading rows AND columns
The scenario – source data sheets that are structured differently! Does Power Query sometimes seem too rigid? It’s great for defining a sequence of transformations to clean your data but […]
Power BI used for Surfing FUN!
A long time ago a peer in Financial Planning and Analysis said “Financial Planning starts in the home.” I modified the statement to “Data analytics starts in the home.”
How to Connect One Slicer to All Your Power BI Report Pages
And another one bites the dust… this month the Power BI team have only delivered the #1 most requested feature on the Power BI Ideas forum.
Power Query (M)agic: Right-Click Your Way To Data Cleaning Happiness
As a ‘water cooler’ of sorts for this community, we meet some amazing people. Doug Burke shares with us how easy Power Query makes it to do powerful cleaning with a click of the mouse.
Using SELECTEDVALUES To Capture Power BI Slicer Selections
Hello P3 Adaptive Nation, I’m excited to be back and writing a technical post again…it’s been too LONG!
Months and Trailing Twelve Months in One Table
Trailing twelve months (TTM) Power BI. Show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance in one table.
A Star (Schema) and a SWITCH for Drill-Down Income Statement Design
When I was first introduced to PowerPivot five or six years ago, I knew it would serve me well in my FP&A function.
Power Query (M)agic: Consecutive Days (Part 2)
Two weeks ago I wrote a blog post about how to create a set of data with Consecutive Days using SQL or Power Query.
Coffee Talk: DAX Pros
n today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment.
Journey to P3 Adaptive : Reid Havens
Buckle in folks, this is going to be a long and engaging article. As we enter 2018, I realized that I’m approaching the one-year anniversary of my first blog post here at P3 Adaptive !
Power Query (M)agic: Consecutive Days
Hello P3 Adaptive World! My name is Krissy Dyess and I have had the most amazing experience working as a full-time consultant at Power Pivot Pro since April 17, 2017!