Forum Discussion

Pier2's avatar
Pier2
Icon for Resolver I rankResolver I
2 years ago
Solved

Remove older year

Hello, I want to remove (circled in red) the first year (as integer value) from a serie. I'm able to find that value, but unable to set right next step, removing it from the final anwse...
Need Help
AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
2 years ago

Try the following :

VAR varPremiereAnne = MIN(CalendrierAnnuel[Année fiscale])

RETURN
CALCULATE(
SUM(tblEntrepriseDonnees[sglCoutCapitauxPropres]),
FILTER(
CalendrierAnnuel,
CalendrierAnnuel[Année fiscale] > varPremiereAnne
),
USERELATIONSHIP(tblEntreprise[KEntreprise], tblEntrepriseDonnees[FKEntreprise])
)

Pier2's avatar
Pier2
Icon for Resolver I rankResolver I
2 years ago

Hello AmiraBedh ,

Thanks for your help.
I've try your solution. The result gives an empty chart, unfortunately. We must be close but I dont where's the problem. I would probably done it like you.

But I can have a sum in a card


The result is the same when I remove the USERELATIONSHIP part.

For the fun of it, I remove varPremiereAnne for 5 or  2015. Then I the chart is full.

 

 

CALCULATE(
SUM(tblEntrepriseDonnees[sglCoutCapitauxPropres]),
FILTER(
CalendrierAnnuel,
CalendrierAnnuel[Année fiscale] > 5
),
USERELATIONSHIP(tblEntreprise[KEntreprise], tblEntrepriseDonnees[FKEntreprise])
)

 

 

  • AmiraBedh's avatar
    AmiraBedh
    Icon for Super User rankSuper User
    2 years ago

    Can you provide some data ? And your model ?

    • Pier2's avatar
      Pier2
      Icon for Resolver I rankResolver I
      2 years ago

      Hello AmiraBedh ,

      The model is the folowing:

       

       

      For a sample of data by table:

      tblEntreprise

      KEntreprisetxtEntrepriseNom
      1Barron's Bar
      2Joy Books Club Inc
      3Cats arrr Great Ltd


      tblEntrepriseDonnees

      IDFKEntrepriseintAnneesglCoutCapitauxPropres
      112014 
      2120150,02
      3120160,05
      4120170,09
      522015 
      6220160,09
      7220170,00
      8220180,08


      As you can see, in row #1 and #5, there's no value in the column sglCoutCapitauxPropres. And I want to hide them from the graph. But when I see a zero, like line #7, I want to see it.

      CalendrierAnnuel

      Année fiscale
      2013
      2014
      2015
      2016
      2017
      2018
      2019


      Hope informations are clear.