Forum Discussion

Digger's avatar
Digger
Post 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
Tahreem24's avatar
Tahreem24
Super User
4 years ago

Digger TRy this Measure:

selpre = CALCULATE(SUM(Base[Percent]),FILTER(All(Base),[Date]<=[Date] ))

NOTE: Make sure Date column is of type Date.

 

  • Digger's avatar
    Digger
    Post Patron
    4 years ago

    Tahreem24  Not work, there are no at all Date table