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.
Category: Power BI
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.
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
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.
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.
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.
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!
Power BI Feature Spotlight: Bookmarks
Every month Power BI gets an update that adds a nice handful of new features. Let’s read about this month’s awesome feature…Bookmarks.
Dynamic Attributes In A Power BI Report
Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.
SUMMARIZE() & ADDCOLUMNS() aren’t scary… if you can SEE them!
I tried solving this problem and the internet led me to SUMMARIZE(). It was stuffed inside another function and it confused me
PowerApps, Flow, and Power BI: Turning Insight Into Action
When working with clients or students, I like to challenge them with this seemingly-controversial statement: Informing people is worthless.