Forum Discussion

polinab's avatar
polinab
Regular Visitor
2 years ago
Solved

sum calculatin using filter and all functions

Hi, Having table below I need calculate total sum after certain time id (10/15/2023 in example) and present it in each cell as following. using filter(Time ID > 10/15/2023) and then all(Time ID) do...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    polinab , Based on what I got

    Assume Completed  is column we need sum

     

    Calculate(Sum(Table[Completed]) , filter(allselected(Table), Table[Time] > Date(2023,11,15) ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

polinab , Based on what I got

Assume Completed  is column we need sum

 

Calculate(Sum(Table[Completed]) , filter(allselected(Table), Table[Time] > Date(2023,11,15) ) )

  • polinab's avatar
    polinab
    Regular Visitor
    2 years ago

    Thank you Amit,

    allselected  worked for me