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

Hi Zubair_Muhammad

 

Thanks for youre notice, Youre measure only depend on Date but I really want to first select Year, month and then day, how to add this filters in youre measure?

    • 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
        Icon for Community Champion rankCommunity 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] )
    )
)