topic Re: Create a Weekly report based on categorised daily data in DAX Commands and Tips

Create a Weekly report based on categorised daily data

andy291086 — Tue, 13 Feb 2024 08:13:27 GMT

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

Anonymous — Wed, 14 Feb 2024 06:22:46 GMT

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 — Fri, 16 Feb 2024 22:52:41 GMT

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