Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
3 years ago

Quarter Difference - Last Year and Current Year

Hello.   I have a time intelligence table.  It calculates correctly the sales by months and by quarters. I also have a table that compares the current year (CY) and last year (LY).   In the date...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Oros What is the difference measure returning? Any chance you can share a PBIX file for this situation. This is the second time recently that I've seen this kind of issue. Not sure we got to the actual root cause of it the last time. You could also try some alternatives to using CALCULATE and TI functions that may help resolve things and quite possibly speed up your calculations to boot.

 

  • Oros's avatar
    Oros
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    Hi Greg_Deckler

     

    Thank you for your quick reply.  What exactly needs to be change to apply the calculate to this measure?

     

    DIFFERENCE =

    SALES (CY) – SALES (LY)

     

    Thanks again.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Oros I was talking about creating alternatives to the other 2 measures to eliminate CALCULATE and TI functions in order to make sure they aren't doing something funky.

      • Oros's avatar
        Oros
        Icon for Post Prodigy rankPost Prodigy
        3 years ago

        Hi Greg_Deckler ,

         

        Unfortunately the entire report is built with TI already.  Would you have any ideas as to why the DIFFERENCE column is not calculating properly if Q2  is selected, even if the SALES (LY) and SALES (CY) are correct?  Thanks.