Forum Discussion
Pier2
Resolver I
2 years agoRemove 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...
- 2 years ago
Hello AmiraBedh ,
I've found a solution after multiple tries and fails.
Translate calculated column into measure
Thanks for your time.
Pier2
Resolver I
2 years agoHello AmiraBedh ,
What i recently found is that when I substract a number (1 or something else) I see the graph. But everything vanish when remove that substraction or try any kind of addition.
//See something in the graph
VAR varPremiereAnnee =
CALCULATE(
MIN(tblEntrepriseDonnees[intAnnee]), USERELATIONSHIP(tblEntreprise[KEntreprise],
tblEntrepriseDonnees[FKEntreprise])
)-1
// See nothing in the graph
VAR varPremiereAnnee =
CALCULATE(
MIN(tblEntrepriseDonnees[intAnnee]), USERELATIONSHIP(tblEntreprise[KEntreprise],
tblEntrepriseDonnees[FKEntreprise])
)
Here's the data model.
Data
tblEntreprise
| KEntreprise | txtEntrepriseNom |
| 1 | Karl's Inc |
| 2 | Joy's Books Store |
CalendrierAnnuel
| Année fiscale |
| 2013 |
| 2014 |
| 2015 |
| 2016 |
| 2017 |
| 2018 |
| 2019 |
tblEntrepriseDonnee
| FKEntreprise | intAnnee | sglCoutCapitauxPropres | ID |
| 1 | 2015 | 1 | |
| 1 | 2016 | 0,02 | 2 |
| 1 | 2017 | 0,03 | 3 |
| 1 | 2018 | 0,025 | 4 |
| 2 | 2014 | 5 | |
| 2 | 2015 | 0,02 | 6 |
| 2 | 2016 | 0,00 | 7 |
| 2 | 2017 | 0,08 | 8 |
As you can see, in tblEntrepriseDonnee, on line 1 and 5, there's no number in the column sglCoutCapitauxPropres. That's why I don't want to see them in the graph. But, as on line # 7, I could find a zéro along the way and I want to see it.
Hope explanations are clear.