Forum Discussion
Solved
Time 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
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 😀😆