I have a MEASURE for a week by week table and need to roll it up for a month by month table

[gforssberg]

See the two tables below. I have a week over week "ghost hours" calculation. Now I need to average the weeks together into a month over month chart. This seems like it would be simple with columns but with measures, it seems tough. I'm sure this is simple but does anyone have an easy answer? 

[amitchandak · Accepted solution]

@gforssberg ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[gforssberg]

Sure. There are several measures, [Total], [Full], [Ghost] and [%] that are calculated for the week in the bottom table. They work correctly. I need to average out the weekly measures to make a month by month view. Does that make sense? It would be (Relative Week 1 +Week 2 + Week 3 + Week 4)/4, essentially. But the adding of measures and having the right filters is throwing me off...

[amitchandak]

@gforssberg , if you want to take an Average of measure above Week Level, you can try like

AverageX(values(Table[Week]), [measure])

[gforssberg]

Worked! I think I had tried this but screwed up the syntax. Thanks for setting me straight, sir!

[gforssberg]

Thanks! I'll try this in the morning. Best