Sums By Specific Date

[btalahmbong]

Is it possible to get the sum of values for a set of dates, then show that sum on a visual as the total on the last date(only last date showed) ?
For Example;

We have a table with 2 columns Date and Sales:

DATE                    SALES

1/1/2017              $100

1/2/2017              $100

1/3/2017              $100

I want to be able to have a visual that returns the sum as follows;

DATE                   SALES

1/3/2017             $300

Thanks for the help!

[MFelix · Accepted solution]

Hi @btalahmbong,

You can use the TOTALMTD, TOTALQTD and/or TOTALYTD if they are combined witha slicer you will get the calculation from the beginning of the month/year until the selected date.

YTD VALUE = TOTALYTD (SUM(Table[SALES]), Table[DATE])

You can then use this.measure card or graph.

Regards,
MFelix