Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago

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...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago

amitchandak  I dontt need it, otherwise it not working also with dat table