Showing results for 
Search instead for 
Did you mean: 
Vrto95 Frequent Visitor
Frequent Visitor

Problems with date scale filtering

HI everyone.

I have some problem with date scale filtering.


I have table and in first column  (which name is "Curr Yr Purchased $) from database I receive current year data, and for second column I create measure like this

prev dollar = CALCULATE(SUM(Query1[PODollars]),DATEADD(Query1[OrderDate].[Date],-1,YEAR))
And I get previous year  or years (depends on my date scale filtering) data.

Besides DATEADD a tried to use PARALLELPERIOD and SAMEPERIODLASTYEAR functions (but nothing work)

pic 1.PNG


As we see the "Curr Yr Purchased $" and "Prior Yr Purchased $" values are same :/


But when I change my date scale filtering only years it's works, but only from 01/01/20xx to 12/31/20xx


Please help me to find problem in first case.


Community Support Team
Community Support Team

Re: Problems with date scale filtering

Hi @Vrto95 ,

Could you please offer your sample file to have a test due to it is hard to reproduce your problem?



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.