Forum Discussion

CoreyPOIA's avatar
CoreyPOIA
New Member
6 years ago
Solved

Weird Behavior in YOY analysis?

Hi PBI Gurus,   I'm requesting your help in trying to figure out some weird behavior of Power BI.    Take a look at my screenshot. The top graph is displaying correct data. The following fields a...
Need Help
  • CoreyP's avatar
    CoreyP
    6 years ago

    Nevermind,

     

    I just fixed it. It looks like I just had to apply a YEAR filter set to 2019.

     

    Thanks for your help!

amitchandak's avatar
amitchandak
Super User
6 years ago

You seem to be using [Total Shipped Orders], which seems like a measure.

 

Can you share its calculation? In case it is a measure, is possible to have the same calculation in last year's formula itself.

 

Thanks

CoreyP's avatar
CoreyP
Solution Sage
6 years ago

Yes, it is a measure, I thought I specified it's calculation in my OP. 

 

Here are my measures.

 

Total Shipped Orders = DISTINCTCOUNT( 'Orders'[Order Number] )

Total Shipped Orders LY = CALCULATE( [Total Shipped Orders] , SAMEPERIODLASTYEAR( 'Date'[Date] ) )

% Change from Last Year = DIVIDE( [Total Shipped Orders] - [Total Shipped Orders LY] , [Total Shipped Orders LY] , 0 ) 

 

My dataset is only 2018/2019.

  • CoreyP's avatar
    CoreyP
    Solution Sage
    6 years ago

    Nevermind,

     

    I just fixed it. It looks like I just had to apply a YEAR filter set to 2019.

     

    Thanks for your help!