DAX – HASONEVALUE vs. ISFILTERED vs. HASONEFILTER
Picking up from Tuesday’s post, which drew some quick comments, let’s add one more function to our evaluation: HASONEFILTER().
Category: Power BI
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.
Tiered Commissions, Income Taxes, and other “Tiered Rate” Calculations Using DAX
Guest post by David Churchward [Twitter] I mentioned in my LAST POST that I would return with a variation on that commission calculation. Two months later and very much overdue, […]
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. […]
Today’s Post Delayed
Yesterday I left Baltimore BWI airport at 11 am heading back to Cleveland. Like basically all of the East Coast air travelers yesterday afternoon though, I never made it home.
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 […]
Self Service BI Doesn’t Mean Desktop Standalone BI
A colleague recently pointed me to a blog post on Birst’s website, that says QlikTech has jumped the shark.
DAX – FILTER() – When, Why, & How to Use It
A recent comment/question alerted me to the fact that I’ve never devoted a post just to this very useful (and often misunderstood) function. Time to correct that.
DAX – Finding the Top-Selling Date, Product, etc.
Greetings from Israel! I’m over here meeting with Microsoft and my old friend Dany Hoter