Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |