Forum Discussion
Solved
Last week calculation
Hi all, I have a problem with calculating the result of last week. A collegue of mine wrote the dax stated below, and it worked. Unfortunately not when we started the new year. Then it looks fo...
Sander1401 I would recommend implementing something like Sequential and then this is trivial. Can also do something similar in PQ. https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
Sander1401 Make sure you are using the right return type for WEEKNUM:
Greg_Deckler I forgot to change one VAR, my mistake, it works now! Thanks again!
