Forum Discussion
Pier2
Resolver I
Resolver IRemove 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...
Hello AmiraBedh ,
I've found a solution after multiple tries and fails.
Translate calculated column into measure
Thanks for your time.
Pier2Resolver I
Resolver IHello AmiraBedh ,
The model is the folowing:
For a sample of data by table:
tblEntreprise
| KEntreprise | txtEntrepriseNom |
| 1 | Barron's Bar |
| 2 | Joy Books Club Inc |
| 3 | Cats arrr Great Ltd |
tblEntrepriseDonnees
| ID | FKEntreprise | intAnnee | sglCoutCapitauxPropres |
| 1 | 1 | 2014 | |
| 2 | 1 | 2015 | 0,02 |
| 3 | 1 | 2016 | 0,05 |
| 4 | 1 | 2017 | 0,09 |
| 5 | 2 | 2015 | |
| 6 | 2 | 2016 | 0,09 |
| 7 | 2 | 2017 | 0,00 |
| 8 | 2 | 2018 | 0,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.
Pier2Resolver I
Resolver IHello AmiraBedh ,
I've found a solution after multiple tries and fails.
Translate calculated column into measure
Thanks for your time.