Presenting Data based on Week Number

[bahare76]

Dear Colleagues,

I wanted to present a column chart with the number of tickets Reported vs Weeks. I have all the tickets from 1 Jan until 31 Jan. The idea is you will compare the number of tickets from Week1, Week 2, Week 3 etc., in Jan 2022. Appreciate your response.

A sample of my data is as in the table below:

Date	Request ID	User	Department	Technician
1/1/2022	1234	John	Legal	Samuel
1/2/2022	1235	James	Finance	Abraham
1/3/2022	1236	Karen	IT	Reece
1/4/2022	1237	Phil	Procurement	Anand
1/5/2022	1238	Lawrence	Legal	Jerry

[v-henryk-mstf]

Hi @bahare76 ,

Whether the advice given by @mahoneypat  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[mahoneypat · Accepted solution]

You'll want to add a Date table to your model that has a Weeks column. Here is a link to a good option. You can use the DAX or M version. You can then relate it to your table on the Date column, and use one of the week columns from the Date table with the Count of one of your columns in the other.

No Sort Date Tables! – Hoosier BI

Pat