Problems with date scale filtering

[Anonymous]

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)

 

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.

Thanks.

[v-danhe-msft]

Hi @Anonymous ,

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

Regards,

Daniel He