averagex

Hey everyone, pretty new to DAX here so still trying to learn, but I'm curious why I'm getting different results when I use an AVERAGEX function vs the the built-in Summarize as Average function in my pivot table? The source data table looks like this: You'll notice that some of the entries...

Sorry for a poor description, essentially in the scenario the granularity of an average was changed by iterating over the linked date table; So to start you have ; Average M:=AVERAGEX(fTransactions,[Total Revenue Iterate Over Fact]) Fine, but do change the granularity this then becomes...

Note: I recently posted my DAX Formula question at the Microsoft Power BI Forums (https://community.powerbi.com/t5/Forums/ct-p/Forums) and had a really bad experience (my post was marked as spam and I could not get help with the issue)... So I am going to try here at mrexcel.com, where I have...

I have a data set with a list of transactions made by 30k customers this year. Each customer might make anywhere from 1 to dozens of transactions a year. I would like to calculate a daily average of the number of customers who make a transaction on each day of the year. (not worried about how...

Firstly, I apologise - I am new to Powerpivot and have tried for a couple of hours to wrap my head around this DAX problem and I cannot afford to waste any more time getting gradually more and more confused. I desperately want somebody to give me a leg-up. In excel. I am presenting a tables...

I have been struggling for a few days trying to get the correct Average to show up in my Pivot table's subtotal. I was unable to make it work with Calculated Fields but by creating a Calculated Column and doing my first calculation inside of it, I was then able to calculate my average field...