Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

1 REPLY 1
v-danhe-msft
Employee
Employee

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.