Forum Discussion
Richard76
Helper II
Helper IITime intelligence formulae
Hi Folks, really struggling with some time intelligence formaulae on power BI. I'm trying to work out sales figures up to the same day the previous year. So in example below I need to compare from 1...
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
Richard76Helper II
Helper IIGetting 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
- Richard76
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 😀😆