What is wrong with my DATEADD

[wbridwell79]

Does anyone know why neither of these are working?  They are returning the Total sum with no date filtered.

Prior Quarter Total COGS = CALCULATE([Total COGS], DATEADD('Calendar'[Date], -1, QUARTER) )
Prior Month Total COGS = IF([Total COGS], CALCULATE([Total COGS], DATEADD('Calendar'[Date], -1, MONTH) ) )

[v-gizhi-msft]

Hello

These formulas work well here in my example:

Please check it out:

pbix

Best regards

Giotto

[mwegener]

Hi @wbridwell79 ,

if the calendar is not filtered, all calendar entries will be shifted by the interval.

Since you probably have more calendar entries than assigned facts, it looks as if all values are returned.

[Greg_Deckler]

Very difficult to say, your [Total COGS] could be a measure and have an ALL in it? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490