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

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 :)

      • austinsense's avatar
        austinsense
        Impactful Individual
        9 years ago

        Ok let me just slow this whole thing down - I would recommend getting a book and reading it. This is the best selling book on the topic (https://www.powerpivotpro.com/the-book/)

         

        You're missing some of the fundamentals of how to put a data model together and that's messing up your formulas / making your formulas impossble.

         

        If you wanna speak to someone who's awesome at this who also speaks french then I can make a recommendation - Tristan Malherbe is excellent.