Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

I need help

Mesure 2015-2016 = CALCULATE(SUM(Factures[2015-2016]);FILTER(ALL(Factures);Factures[Mois.Date] >= DATE(2015;07;01) && Factures[Mois.Date] <= MAX(Factures[Mois.Date])))   Bonjour, J'aimerais rempla...
Need Help
austinsense's avatar
austinsense
Impactful Individual
9 years ago

D'accord.  You should make two formulas - You'll need to have a calendar table in your model.

 

Current Year (YTD)

 

Current Year (YTD) = CALCULATE([Revenue], DATESYTD(CalendarTable[Date]) )

 

 

Last Year (YTD)

 

CALCULATE([Current Year (YTD)],DATEADD(Calendar[Date],-1,YEAR) )

 

 

AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

pour l'instant lorsque je les met en séparé tout fonctionne normalement mais des que je souhaite les réunir sour un même c'est le drame.

 

For the moment when I put them separated everything works normally but of the that I wish to join them to the same one it is the drama

 

  • austinsense's avatar
    austinsense
    Impactful Individual
    9 years ago

    Here's the trick - don't make a measure for every year.  Make one measure and then use a calendar table to slice the different years.

    • AlexGallet01's avatar
      AlexGallet01
      Helper IV
      9 years ago

      Je dois donc faire comme vous avez fait avant et en plus mes anées sont de juillet en juin de l'an d'après comment faire ?

       

      So I have to do as you did before and in addition my years are from July to June of the following year how to do?

      • austinsense's avatar
        austinsense
        Impactful Individual
        9 years ago

        Just give it a try :)

    • AlexGallet01's avatar
      AlexGallet01
      Helper IV
      9 years ago

      and i need the total for each month for each year