Forum Discussion

sdionne's avatar
sdionne
Frequent Visitor
8 years ago
Solved

Compare sales

Hi, in one table I have all sales, I can compare sales from selected year and previous year, my problem is with actual year, I want to summerize previous year sales only to the same date as today but last year:

In this example I want sales last year until november, and when I will have december sales, I wants only too last year december sales.

 

Thanks

sdionne

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    =IF(ISBLANK(Ventes[Ventes]),BLANK(),CALCULATE(Ventes[Ventes];DATESYTD(Calendrier[Date];"30/09"))

     

    Hope this helps.

8 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi sdionne

     

    What formula are you using for your measures?

     

    I had some success with the following:

     

    Ventes Total YTD = TOTALYTD(SUM('Sales'[Ventes]),'Dates'[Date])

Ventes Total Annee Pre YTD = TOTALYTD(SUM('Sales'[Ventes]),SAMEPERIODLASTYEAR('Dates'[Date]))
    • sdionne's avatar
      sdionne
      Frequent Visitor
      8 years ago

      Hi Phil, I tested yoyr formulas and it's not working for me.

      My formulas are:

      Ventes Total YTD = CALCULATE(Ventes[Ventes];DATESYTD(Calendrier[Date];"30/09"))

      Ventes Total Année Précédente YTD = CALCULATE(Ventes[Ventes Année Précédente];DATESYTD(Calendrier[Date];"30/09"))

       

      Please note I calculate according to fiscal year from oct. to sept.

       

      Thanks

      Sylvain

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        You are missing the SUM function.  Try this

         

        =CALCULATE(SUM(Ventes[Ventes]);DATESYTD(Calendrier[Date];"30/09"))

         

        Also, ensure that in your visual, you draf Year/months/days from the Calendar table.