Create a year to date measure

Last modified by Aurelie Bertrand on 2020/07/29 16:38

{{toc/}}

----

= Create a new calculated measure =

* Add the measure on which you want to apply the year to date
* Click on the measure, add a date dimension
* Add a filter and use a function predefined, select “Year (Selection)”
This measure will do the cumulation from the beginning of the year to the date chosen in the date selector. This means that a date selector must be present in the dashboard with hierarchy (% style="color:#16a085" %)**Year Month**

= Graphic illustration =

[[image:https://lh5.googleusercontent.com/f6__6vTsSEGB3W_wS1jWDuTCHiyKhXJl930RbQCIhcHDH-iZ6UtHdUmiwc3SHmscc8Y3TTIzyDsrajCueQwcqoHOByFRaRslpHk1xNzrRwuw5rrFgtq237FQN_VJFoSAEcik_19VCLM||height="457" width="847"]]