Year over Year Comparison by Week

[reh169]

I have data for several grabed every Friday. The date that I use for this is the load date. I want to be able to graph the data year over year by week. How do I this? Here is a sample of what the data looks like. I am listing it in rows by city.

[v-lid-msft]

Hi @reh169 ,

We can add a calculate column Week to meet your requirement.

Week = WEEKNUM('Data'[Date])

If it doesn't meet your requirement, Please show the exact expected result based on the Tables in sample pbix file.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[reh169]

So it seems that the weeknum calculation will only work if there is one instance of the date. I have more than 50 lines of data for each date. I am looking at yard data so I have lots of yards that have data for those specific dates. Is there another function that will work?

[v-lid-msft · Accepted solution]

Hi @reh169 ,

The weeknum function will calculate for each rows when create a calculated column, if there are multi rows have same date, they will have the same week number, then the value will calculate all the data with the same week.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.