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"))

     

     

miggy46's avatar
miggy46
New Member
2 years ago

This worked for me
Column = CALCULATE(SUM(Table1[Value]),Table1[Date&Time]).