Forum Discussion

Aliafshari's avatar
Aliafshari
Frequent Visitor
8 years ago
Solved

sum before a day

Hi everyone!  Assume that I have selected Year, Month and Day in slicer in below tale, I would like to sum the Quantity before the selected time dimension, How could I do that?   Date             ...
Need Help
Aliafshari's avatar
Aliafshari
Frequent Visitor
8 years ago

Sorry  Zubair_Muhammad 

One more question, Consider we add a column name as Main account, how to sum before a day for each of main account in a table?

 

 

Date          Main account        Quantity

 **                      **                     **

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    HI Aliafshari

     

    In that case use this MEASURE. Then drag it to the TABLE visual along with the account names

     

    Sum_Before_Selected_Day =
CALCULATE (
    SUM ( TableName[Quantity] ),
    FILTER (
        ALLEXCEPT ( TableName, TableName[Main Account] ),
        TableName[Date] < SELECTEDVALUE ( TableName[Date] )
    )
)