DAX – SUM, SUMX or CALCULATE()…Choices, choices!
When I was working recently with a client, helping her remotely – I asked her to calculate the sum for sales amount in the table. She responded whether she should use SUM, SUMX or CALCULATE?
Search Results for: https://ww
DAX – The Many Faces of VALUES()
aybe it is a sign of where I am on the Geek Scale compared to Rob, but where he considers EARLIER() to be a pretty hard function to understand, it just doesn’t bother me. At least it seems to have just one purpose in life.
“I Modified an Existing Table in Power Query and Now it Won’t Refresh”– A Fix
It’s the same old story, I mashed and twisted some data through Power Query, pulled it through Power Pivot, spent hours creating calculated columns and measures, made a really nice Pivot Table with conditional formatting and all the bells and whistles.
DAX – Week Ending Date Calculation
The first thought to occur to me was “well, for each Year&WeekOfYear, I just want to grab the max date”. That sounded easy enough… EARLIER() no longer scares me
Two Quick Updates: University Re-Launches Monday. And Power Query is Amazing. AMAZING.
What can I say folks. The Power Pivot “biz” continues to gain steam (one indicator: last week recorded the highest traffic ever to this site) and that means busy days here at P3 Adaptive HQ.
A Simple Measure for Projections with Act! CRM
Continuing the series of guest posts that got temporarily shelved, today we have one from Vivek Gargav.
Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros
Excel 2013 public preview (aka beta) is out, which means that now we’re not only playing around with PowerPivot V2 and Power View V1, but now we have another new set of toys to take for a spin.
Dynamic TopN Reports via Slicers, Part 4 – The Dot Plot PivotChart
After completing the Part 3 extension of Rob’s Dynamic TopN Reports via Slicers, Part 2 post, I did not plan on a forth installment.
A Brief Note on PowerPivot and Custom PivotCharts
Guest Post by Colin Banfield [LinkedIn] In the next few posts, I plan on demonstrating techniques for creating various types of custom PivotCharts that use PowerPivot data and DAX measures. […]
Dynamic TopN Reports via Slicers, Part 3
After Rob posted Dynamic TopN Reports Using PowerPivot2!, I downloaded the workbook from the provided link to examine how his “tricks” were done
Wingdings and Other Symbolic Fonts in Slicers!
Someone planted an idea in my head the other day: “hey can we use the Wingdings font in slicers?”
Dynamic TopN Reports via Slicers, Part 2
OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique. Slicer tables […]