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!

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution 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
Icon for Solution Sage rankSolution 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!