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, 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,