Forum Discussion

AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper 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
AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper 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
Icon for Impactful Individual rankImpactful 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
    Icon for Helper IV rankHelper 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
      Icon for Impactful Individual rankImpactful Individual
      9 years ago

      Just give it a try :)

  • AlexGallet01's avatar
    AlexGallet01
    Icon for Helper IV rankHelper IV
    9 years ago

    and i need the total for each month for each year