02-17-2019 05:25 AM
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.
02-18-2019 05:46 PM
Hi @Vrto95 ,
Could you please offer your sample file to have a test due to it is hard to reproduce your problem?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.