Forum Discussion
Cumulative Total with Dynamic Date Variables and Slicers - Line Chart Behavior Question
Yes your Calendar table is ok and yes you need to use time intelligence functions if you want to use the Calendar table.
I rechecked your measures here
and I don't think it is quite wise to use them. Why !!
like this one here with the if condition
you telling the measure, if no month of the selected year of the same month is not selected then continue the running total with the sum of datat from the the next month of the next year...that's why you see the line chart goes beyond Spetember.
So better use TI functions to make things more easier.
Community ChampionYes your Calendar table is ok and yes you need to use time intelligence functions if you want to use the Calendar table.
I rechecked your measures here
and I don't think it is quite wise to use them. Why !!
like this one here with the if condition
you telling the measure, if no month of the selected year of the same month is not selected then continue the running total with the sum of datat from the the next month of the next year...that's why you see the line chart goes beyond Spetember.
So better use TI functions to make things more easier.
Hi Amine,
That makes sense. I will revise my measures. Thank you for your help.