Create a Weekly report based on categorised daily data

[andy291086]

Hi all, 

I had been tasked to create a weekly aggregation report ,which uses a dataset similar to below. 

And the expectation was to create a dashboard like below .. 

The top row in the output is expected to be a slicer and the other measures are calculated at weekly grain. 

Can someone help with ideas on how to create this report. I am facing issues in creating weekly measures on daily data. 

Cheers,

Andy

[andy291086]

Its not just sum I was looking at. I am looking at calculating all the other parameters, like Rolling Average etc

[Anonymous]

Hi @andy291086 ,

Based on the information you provided, here is my brief analysis.

I created a simple table.

If you want to calculate the value of their Sum you can enter the following DAX code.

Total Work Hours = SUM('Table'[No. of Work Hours]) 

Then you will see the Total Work Hour.

You can also create a column to calculate the Week Number.

Column = WEEKNUM('Table'[Date])

Use a slicer and you can get what you want.