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
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper 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
    Icon for Post Patron rankPost Patron
    4 years ago

    Tahreem24  Not work, there are no at all Date table