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

     

     

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

Anonymous , New columns

 


new column =
var _date = datevalue([Date&Time])
return
sumx(filter(Table, datevalue([Date&Time]) = _date ), [Value])

 

 

new column =
var _date = datevalue([Date&Time])
var _max = maxx(filter(Table, datevalue([Date&Time]), [Date&Time])
return
if([Date&Time] =_max, sumx(filter(Table, datevalue([Date&Time]) = _date ), [Value]), blank())