Forum Discussion
Time intelligence formulae
Jesus it's still morning here I can't seem to do what I was thinking 😂
There was a parentisis missing sorry!!
Sales LY = CALCULATE([Total Sales],DATESBETWEEN('Time'[PK_Date],MIN('Time'[PK_Date]),MAX('Time'[PK_Date])-365)BR,
DR
Sorry I'm probably not explaining clearly. I already have a formulae in as you suggested but the issue is I also have a date slicer in as well which runs from 1/1/19 - 8/1/2020 . When I try the formulaes you suggested it gives me the sales for the full year (I have data running from 2018) but I only want from 1/1/19 - 8/1/19 if that makes sense
Hi again Richard76,
I may have misunderstood, in that case I would use dates between in the calculate formula, like
LY Sales = calculate([total sales],DATESBETWEEN(DATE,MIN(DATE),MAX(DATE)-365)
I'm not sure but I think this might work, let me know 👌
Getting an error with that formulae 'too few arguments were passed to the DATESBETWEEN function but cant work out where it is wrong
Sales LY = CALCULATE([Total Sales],DATESBETWEEN('Time'[PK_Date],MIN('Time'[PK_Date],MAX('Time'[PK_Date])-365)Jesus it's still morning here I can't seem to do what I was thinking 😂
There was a parentisis missing sorry!!
Sales LY = CALCULATE([Total Sales],DATESBETWEEN('Time'[PK_Date],MIN('Time'[PK_Date]),MAX('Time'[PK_Date])-365)BR,
DR
Thanks you so much this works a treat and is so much easier than some of the other 'solutions' I was trying to follow online.
Now get some sleep 😀😆