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

amitchandak   no one measure is not working!!!

amitchandak's avatar
amitchandak
Super User
4 years ago

Digger ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Digger's avatar
    Digger
    Post Patron
    4 years ago

    amitchandak everything shared in my post

    • amitchandak's avatar
      amitchandak
      Super 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
        Post Patron
        4 years ago

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