Reply
Frequent Visitor
Posts: 2
Registered: ‎02-17-2019

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

pic2.PNG

Please help me to find problem in first case.

Thanks.

Community Support Team
Posts: 2,276
Registered: ‎06-24-2018

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?

 

Regards,

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.