Line Chart

[andfx]

Hi,

I have one table with that data:

date	        balance
01/02/2016	1200
20/02/2016	500
01/03/2016	700
03/03/2016	1000
08/03/2016	1200
28/12/2016	800
03/02/2017	700
27/07/2017	300
05/09/2017	200
01/10/2017	1000
12/01/2018	300
12/02/2018	500
12/03/2018	600
12/04/2018	200
12/05/2018	300
12/07/2018	400
13/08/2018	900
15/08/2018	1200
01/09/2018	700

Each day we have the balance value.  It's not to be summed. For example. Balance of Feb/2016 is 500. Balance of Mar/2016 is 1200.

And so the year. The balance of year is the last value of that year. For example, balance of 2016 is 800.

I did a line chart with every value, that's ok my visualization by day.

Occurs that I need to filter it by MONTH and YEAR.

For example, for the YEAR, that is my chart:

Actually, I would like to get this result:

Because it is the LAST VALUE (not necessary the MAX) of that YEAR.

date         balance
28/12/2016   800       
01/10/2017   1000       
01/09/2018   700 

I would like to do that to MONTH too.

I thought about doing a new table for a MONTH, for YEAR with each of those values. Occurs that I have more than 100 of those examples. Each one is a client.

Is it possible to do a FILTER for that?  If not, how can I do that using columns?

Thank you,

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[mwegener]

Hi @andfx

maybe this helps

Measure = CALCULATE(SUM(Table1[balance]); FILTER(Table1;Table1[date] = MAX(Table1[date])))