Previous Day Sales DAX not working

[Anonymous]

I can't seem to get the previous day sales DAX to work:

Previous Day Sales = CALCULATE(SUM(AssaySales[Extended Sales PMAR Amount], PREVIOUSDAY('AssaySales'[Ship Date (MM/DD/YYYY)]))). The error says there's an unexpected parameter ', PREVIOUSDAY('AssaySales'[Ship Date (MM/DD/YYYY)])'

I've added two pictures of my table (same table, two separate screenshots because the table was so large).

Any thoughts?

[naveenmechu]

Hi,

You missed to close sum function, use below one--

Previous Day Sales = CALCULATE(SUM(AssaySales[Extended Sales PMAR Amount], PREVIOUSDAY('AssaySales'[Ship Date (MM/DD/YYYY)])))

and its better if you create seprate date table.

Let me know, if you still face chellenge.

Thanks

Naveen Mechu

[Anonymous]

@AllisonKennedy  here's the DAX with the DimDate suggestion. 

Previous Day Sales = CALCULATE(SUM(AssaySales[Extended Sales PMAR Amount]),PREVIOUSDAY('DimDate'[Date].[Date]))

It's still not populating an accurate value. It's calculating the sum of the last two years (2020 and 2021), which is the date range of my dataset. It seems like I need to do an IF function but I don't know how to do that in Power Bi, only excel. Mind helping? 

[AllisonKennedy]

@Anonymous what are you trying to get? I use DATEADD function for most basic scenarios, not sure if that's what you're looking for here?

Previous Day Sales = CALCULATE(SUM(AssaySales[Extended Sales PMAR Amount]),

DATEADD('DimDate'[Date],-1, DAY)

)

[AllisonKennedy · Accepted solution]

@Anonymous  - when troubleshooting DAX errors, look for where the red squiggly underline begins - you're missing a close bracket near that point after the SUM function, see in bold red below: 

Previous Day Sales = CALCULATE(SUM(AssaySales[Extended Sales PMAR Amount] ), PREVIOUSDAY('AssaySales'[Ship Date (MM/DD/YYYY)] ) )

Also, very IMPORTANT, you need a DimDate table for the PreviousDay function to work properly: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html