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 ...
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.