Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Weekly sales

Hello everybody   i need question I am showing sales data  by weekly. I m showing my data by  WeekYear   And it shows: Last days of Year end  2019.12. 29 - 31 (3 days) are 53rd week of 2019 2...
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

Using what you already have, you could create a new calculated column:

Week of the year 2 =
IF (
    ( Table1[year] = 2019 && Table1[ Week of the year] = 53 )
        || ( Table1[year] = 2020 && Table1[ Week of the year] = 1 );
    1;
    Table1[ Week of the year]
)

 

What we are doing is imply assign week number 1 to both week 53-2019 and week 01-2020 and leave all the rest as it already was.

 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  Datanaut

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello

    Thank you very much for your answer.

    I used your DAX expression. But it shows same as before. Or i made mistake with my expression.

     

     

    • AlB's avatar
      AlB
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi Anonymous 

      You haven't copied my code correctly. The second check is on [Week of the year], not on [year]

       

      Week of the year 2 =
      IF (
      ( Table1[year] = 2019 && Table1[ Week of the year] = 53 )
      || ( Table1[year] = 2020 && Table1[ Week of the year] = 1 );
      1;
      Table1[ Week of the year]
      )

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        oh it was my mistake. Thank you very much again. 😊 You saved me.