Forum Discussion
Digger
Post Patron
Post PatronSum 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...
DiggerPost Patron
Post Patronamitchandak no one measure is not working!!!
amitchandak
Super User
Super UserDigger ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- Digger
amitchandak everything shared in my post
- amitchandak
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