How to show the cumulative value at the kpi chart

[afiqaz-97]

Hi, I have problem where by my KPI chart shown the recent value and not the cumulative value in the default value which refer to the picture below it shows the value for April and not the sum value of all months until April?. Can you give me some ideas how to figure out. Here are some of the attachment to help you visualise my problem.

[Anonymous · Accepted solution]

Hi @afiqaz-97 

Please correct me if I wrongly understood your question.

You said you want to sum value of all months until April , my understanding is that you want to compare the sum of all data from January to April last year with the sum of all data from January to April this year .Is it ?

You can create two measures to calculate the data of the first 4 months for last year and the data of the first 4 months for this year. And then add these measures in visual .

previous year = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Date]>=DATE(YEAR(TODAY())-1,01,01) && 'Table'[Date]<DATE(YEAR(TODAY())-1,05,01)))

current year = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Date]>=DATE(YEAR(TODAY()),01,01) && 'Table'[Date]<DATE(YEAR(TODAY()),05,01)))

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

This measure will calculate the YTD figure

=calculate([your measure],datesytd(calendar[date],"31/12"))

Hope this helps.

[afiqaz-97]

I've try out and modified some because the calculate needs another function to read my data and column but it appear this error. Really appreciate for the help. Thanks in advance 

[Ashish_Mathur]

Hi,

You should close the SUM bracket before the first comma.  Also, the first inout of the DATESYTD() function should be Calendar[Date].  So you must first build a Calendar Table and create a relationship between the Date column of the RAW_RO table to the Date column of the Calendar Table.