Forum Discussion
help with getting total between two dates
I am having issues getting the right dax measure to find the cummulative total between two dates in the past. the tricky part is i need to go back a 6mth period and then get the total of the previous...
No wonder it doesn't work... If you closely look at the definition of DATEADD (as you should do with all functions the functionality of which you don't fully know), you'll notice that it returns A TABLE, not a value. But DATESBETWEEN expects single values as the 2nd and 3rd argument.
dax.guide/datesbetween/
dax.guide/dateadd/
So, if you get the right dates and then stick them into DATESBETWEEN, you'll get a correct answer.
Best
D
dax.guide/datesbetween/
dax.guide/dateadd/
So, if you get the right dates and then stick them into DATESBETWEEN, you'll get a correct answer.
Best
D