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

Anonymous 

Try this for your column WeekYear

 

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

 

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

Cheers  Datanaut

 

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

 

With the code for WeekYear in the previous post, you don't need the [Week of the year 2] column any more

 

 

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

Cheers  Datanaut