Forum Discussion
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
Community Champion
Community ChampionAnonymous
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 
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
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