-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
granularity
-
D
AVERAGEX iterating over one table with calculation on another
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...- dicken
- Thread
- averagex dax granularity
- Replies: 5
- Forum: Power Tools
-
C
Using data from two tables with different granularity
Hi, I have two data tables. One has actual sales by Customer and Product code (Sales_By_Customer). The second (Sales Forecast), contains a total sales forecast by Customer only. I'm trying to calculate and chart the variance to target for each customer. I've created this measure: Target v...- Chalklands
- Thread
- chart customer granularity power bi sales
- Replies: 4
- Forum: Power Tools
-
T
One to many: every "many" displaying for every "one"
Hi All, I'm looking for assistance with a modelling question that I've hit a few times in Powerpivot: displaying only *related* row labels from the many side of the relationship, as a subordinate row label to the "one" side records. I have an example model screengrabbed that I think makes the...- TheUnit
- Thread
- granularity records row side
- Replies: 5
- Forum: Power Tools
