Forum Discussion

therenjithr's avatar
therenjithr
Frequent Visitor
4 years ago

Report Showing incorrect YearWeek combination - 202156, 202155, 202154

I am trying to create a weekly report from daily data. Since the data include last 10 years, I had to concatenate year and week e.g: 202202, 202201, 202153, 202152....with below Query and converted below format to whole numbers.

=Text.From([Year]) & "" & Text.PadStart(Text.From([Week of Year]),2,"0")

Everything was good untill I created report. In the report x axis is showing 202202, 202201, 202156, 202155, 202154, 202153, 202152.

 

So the YearWeek combination is also adding incorrect YearWeek combination. Please guide

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi therenjithr ,

     

    You need to check if 56, 55 and 54 exist in [Week of Year].

    How did your [Year] and [Week of Year] come from?

     

     

    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.