Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |