Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax - Sum values by date

Hi team, I have Date and Value columns coming from one table, and I need a new calculated column to show the total sum of the values by date. Date&Time Value Needed result (SUM by date) ...
Need Help
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Anonymous So, make the following tweak in that measure:

     Result1= CALCULATE(SUM(TableName[ValuesColumn]),ALLEXCEPT(TableName,TableName[Date_]),TableName[Task Desc]="MO"))

     

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Anonymous Follow the below steps to get the result.

Step 1: Create below column which only extract the Date part from your date column.

Date_  Column= LEFT(TableName[YourDateColumn],10)
 
Step 2: Create a DAX measure like below:
Result1 = CALCULATE(SUM(TableName[ValuesColumn]),ALLEXCEPT(TableName,TableName[Date_]))
 
Step 3: You'll get the result like below:
 
 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak ,

Thank you for your response. Currently, I have an additional filter for my whole table (apologies for not mentioning it before). The column is Task Description - "AM", "MO", and my table is filtering to show dates and values only for Task desc. = "MO". 
By using your formula I received the sum of all values for a day (AM & MO). The filter applied to myreport page didn't affect the new Calc. column. 

Is it possible the "New column" to show the sum of values only where the Task Desc = "MO".

Thank you.