Forum Discussion
Weekly sales
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.
Community ChampionHi 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]
)
oh it was my mistake. Thank you very much again. 😊 You saved me.
How to change the DAX expression like adding expression of changing 53th of 2020 into 1st week of 2020?
thanks again
- AlB
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
- AlB
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