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...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for your answer.

But my question was

How should i add more years on the DAX expression?

For example 2021, 2022...

 

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]
)

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

 

Anonymous 

Try this

Week of the year 2 V2 =
IF ( Table1[ Week of the year] = 53; 1; Table1[ Week of the year] )

 

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

Cheers  Datanaut