Forum Discussion
DAX or Power Query
Hi Everyone, My question is, how do I find the sum of prior qty available in the past 13 weeks starting from today and going back 13 weeks. Here is a mock dataset of the main table. This table...
Instead of the MAX filedate, use TODAY(). see this link for a description of the function and its caveats:
https://docs.microsoft.com/en-us/dax/today-function-dax
Also, please take a look at the function DIVIDE(). It is considered best practise to avoid divisions using "/".
Martijn
Hi Martijn,
I have already tried TODAY() in place of MAX, but I get a blank data result on doing so.