Forum Discussion

Richard76's avatar
Richard76
Helper II
6 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 👌

Richard76's avatar
Richard76
Helper II
6 years ago

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)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Richard76
      Helper II
      6 years ago

      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 ğŸ˜€ğŸ˜†