Peak Detection: A Surprising Usage of DAX
In a recent post I covered a very simple scientific scenario. It was an interesting diversion from the normal biz-style scenarios but it left me feeling hollow in two ways.
In a recent post I covered a very simple scientific scenario. It was an interesting diversion from the normal biz-style scenarios but it left me feeling hollow in two ways.
I’ve got another article about to go live on CIMA Insight, but I’m gonna jump the gun a bit and post basically the entire thing here ahead of time.
Another one from the Mr. XL Forum!
…and the word “forum” gives me an excuse for a blast from the past…
OK, let’s say you already installed v2, whether inadvertently or… advertently. And now you need to downgrade to v1, so that your workbooks function on your server
The Mr. Excel PowerPivot Forum has inspired me to change gears a little bit and focus more time on simple techniques that don’t break the DAX Spicy Scale
Enjoying the new forum! I’ve been spending some time on the Mr. Excel PowerPivot forum over the past few days and I must say I am enjoying the experience.
The other day I suggested to Bill Jelen that he might want to add a PowerPivot-dedicated forum on MrExcel.com. I wasn’t sure what he would say, to be honest.
You’ll often hear us Accountants referring to things like adjusting for timing differences or prepaying costs or deferring revenue.
Quick Recap: We Created a Separate “Periods” Table In last week’s post, I explained how PowerPivot can very easily help you solve the “Budget vs. Actuals” problem or any other problem where you have data sets
Some of you know that I’ve been writing a series of articles for the Chartered Institute of Management Accounts, aka CIMA
I thought today was going to be a “handful of mini posts” kind of day but then this post blossomed into a bit more than I thought it would, which is a good thing.
There’s few, if any, reports that I consider to be more important than the Cash Flow Statement.