Forum Discussion

andy291086's avatar
andy291086
Frequent Visitor
2 years ago

Create a Weekly report based on categorised daily data

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

  • andy291086's avatar
    andy291086
    Frequent Visitor
    2 years ago

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