Forum Discussion
Solved
Sums By Specific Date
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!
- 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
1 Reply
- 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