Nested SUMX or DAX Query?
I was helping a friend out recently with an interesting problem. It all started with a SUM( ) that wasn’t behaving.
Tag: SUMX
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?
DAX – SUMX of IF: A Perfect Blend of Simple & Sophisticated
In This Case, Getting the Grand Total Correct for Each Row Required SUMX It’s that time of year again… …when my love of spreadsheets actually translates into a love of […]
Commission Calculations using DAX Part 2
You may recall in my last post, COMMISSION CALCULATIONS IN POWERPIVOT, we got to the point where we could dynamically calculate the sales value and attributable commission rate that should be applied based on time, value and team parameters, reading from a Rates table.
Prepayments & Deferred Revenue Using DAX
You’ll often hear us Accountants referring to things like adjusting for timing differences or prepaying costs or deferring revenue.