I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering topics on business intelligence and data. 120 more words
Tags » DAX
This Workout introduces another use of the All function so that results in the pivot can be compared to baseline data.
See the below PowerPivotPro post for all the information you’ll need on understanding the ALL function. 108 more words
This workout shows how the DAX Function HASONEVALUE can be used to remove Grand Totals. Often the pivots we create have useless Grand Totals that are confusing to the report consumers. 141 more words
On a recent project at work, I ran into some performance issues with reports in Excel built against a Power Pivot model. I had 2 Power Views and 2 Excel pivot table reports, of which both Excel reports were slow and one Power View was slow. 955 more words
After almost 2 months of struggle which saw major indices in a whipsaw, the desire for stocks has returned in spades. Indeed, look no further to the QQQ chart which gives the most telling story, as the floodgate was opened ever since the breakout from the final line of defense which bore major significance: 237 more words