Solved: Calculate the same day for the same week of the pr...

PacosdjNew · ‎03-17-2022

Hello everybody,
I would need to calculate the Monday of the previous year based on the Monday of the current year (same week number).

For example 03/14/2022 was Monday of week number 12, I should find the Monday of the same week of the previous year.

So for Monday 03/14/2022, I should find Monday 03/15/2021.

Thanks so much

CNENFRNL · ‎03-17-2022

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

CNENFRNL · ‎03-17-2022

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!