Forum Discussion

PBIn00b's avatar
PBIn00b
Icon for Advocate II rankAdvocate II
10 years ago

PREVIOUSDAY isn't working... help?

I am attempting to get a previous day's value.  Unfortunately it doesn't seem to be working for me.  Here is the formula I am using:   Previous Day Sales = CALCULATE(SUM('table'order_total]),PREVIO...
Vicky_Song's avatar
Vicky_Song
Icon for Impactful Individual rankImpactful Individual
10 years ago

PBIn00b, thanks for reporting it. Your issue can be reproduced and I reported it internally. I will post back once I get any feedback. 

  • Vicky_Song's avatar
    Vicky_Song
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    PBIn00b, with the Previous Day Sales = CALCULATE(SUM('table'order_total]),PREVIOUSDAY('table'[ship_date])) formula, set field under Values from "Date Hierarchy" to "DueDate", then data shows up correctly. 

    Or, you can have the DAX to be similar to: 

    CALCULATE(SUM('Purchasing PurchaseOrderDetail'[UnitPrice]),PREVIOUSDAY('Purchasing PurchaseOrderDetail'[DueDate].[Date]))

     

    • Leila's avatar
      Leila
      Regular Visitor
      9 years ago

      Hi
      I have the same problem, while niether PREVIOUSDAY nor DATEADD functions work when I want to calculate the SUM(sessions) for a previous period. ( I need this calculation to know the growth rate for day over day

       

      I have searched the whole powerbi community in the last three days, and much to my surprise, it is still unresolved :(

       

      This is my formula : PreDaySessions = CALCULATE(SUM(Visitor[SessionS]), DATEADD(Visitor[Date].[Date], -1 , DAY))

       

      Thanks in andvance,