Forum Discussion
Digger
4 years agoPost Patron
Sum by category until date
I have i table How to write measure to sum by Code until date Not working measures: selpre = CALCULATE(SUM(Base[Percent]) ) selpre = CALCULATE(SUM(Base[Percent]), DATESYTD(Ba...
amitchandak
4 years agoSuper User
Digger , You need to have a date table and you need to join it with the date of your table. Then use year and month from date table
and this formula should work
selpre = CALCULATE(SUM(Base[Percent]), DATESYTD(Date[Date]))
Digger
4 years agoPost Patron