Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Year over Year Comparison by Week

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 dat...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

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.