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 an...
- 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
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
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