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.
Search Results for: https://ww
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.
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
On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.
One of my colleagues and I have been geeking out the last few years over all things Power (Query, Pivot, View, and now BI).
Coffee Talk: The PowerON Pros
Welcome to the latest P3 Adaptive Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general.
Coffee Talk: The Partnership Pros
Over the summer P3 Adaptive achieved our Microsoft Partner Gold Competency in Data Analytics. As part of our increasing focus on our partnership with Microsoft we invited Tamer Farag, the Global Partner Ecosystem Lead for Power BI, PowerApps and Microsoft Flow at Microsoft, to participate in our latest coffee talk. Below is a transcript of a Slack conversation held 8/30/2017, edited for clarity and brevity.
DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)
Today, I’ll show you how to bring the awesome to moving averages with DAX text formulas for slicers and titles… and yes, I’ll throw in a Greatest Formula In the World (GFITW) version, too.
Coffee Talk: The Tabular Pros
Ok so we missed a week. We had a busy training in Denver last week. Good news is we’re baaaaaaaaaack and with a great lineup of Tabular Pros.
Chatting with John Michaloudis & Rob Collie
The #1 Supporter of our 2nd Edition Book Sits Down for a Virtual Interview
Power BI (DAX and M) vs. R: A Summer of Perspective
Based on what I’ve learned from Zoe, and what I’ve read to fill in the gaps, I think the two big differentiators are “how much statistical rigor do you require” and “how many different variations of the question do you need to ask?”