Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

sum up value based on category

hi guys, please help with the problem statement : the data is categorized by fiscal period but currently i want the DAX to calculate the sum of sales per month on the "sum up sales per month" column,...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    Create a measure like this :

    Sum up sales per month = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[month in quarter]))

    You will get a result is as follows :

    I have attached my pbix file , you can refer to it .

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 
you can make a Summary Table like 

Summary Table =
SUMMARIZE(Table,fiscal period,month in quarter,"Sum up sales per month",SUM(Sales))