How to get my graph on a By Week basis?

[BPTBPTBPT]

I would like to make a graph showing how many documents are created per week.

I have a table for these documents with a column that shows the date created for each document.

I also created a date table using this tutorial: https://www.youtube.com/watch?v=mLiPm82GRUo&ab_channel=EnterpriseDNA

But.. How do I proceed? I though using the week column from the date table on the X-axis and the 'date created'' column on the y-axis would do the trick, But then I get a graph that just shows the same value for every week:

[Anonymous]

Hi @BPTBPTBPT ,

From your screenshot, it seems that the dates in the calendar table do not create a relationship with the dates in the main table.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In the Date Table, create columns for Week and Year.  To the x-axis of your visual, drag Year and Week from the Date Table.  Write this measure

Measure = countrows(Data)

Hope this helps.

[VahidDM]

Hi @BPTBPTBPT 

Check this link, might be helpful:

https://www.vahiddm.com/post/weekly-time-intelligence-dax

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/