Forum Discussion

alexcatala's avatar
alexcatala
Icon for Helper IV rankHelper IV
5 years ago
Solved

Create weekly units from daily units

Hi,   I am currently trying to create a measure to obtain the weekly units based on the daily units.  In this Data the daily unit is the QTY.    I have also the week in this database, so I...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi alexcatala ,

     

    You could use ALLEXCEPT() to calculate the sum of each group:

    Measure = CALCULATE(SUM('Table'[Qty]),ALLEXCEPT('Table','Table'[Store],'Table'[Week]))


    Please take a look at the difference outputs:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

alexcatala's avatar
alexcatala
Icon for Helper IV rankHelper IV
5 years ago

amitchandak 

 

As you can see I have daily units (QTY) and the last column gives the week num (Week)

I would like to be able to sum all the weekly unit and could filter by store and week.

 

thanks for your help

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

alexcatala , In a table/matrix or any visual. Take un summarized week column and sum(table[Qty]) , you will week wise data.