Forum Discussion

Barre's avatar
Barre
Helper I
5 years ago
Solved

Sum per Day

Hi, I have this table visual with OrderDate and a Amount measure. The OrderDate is of type Date, with Date Hierarchy off in the table.   What I´m struggeling to achieve is to visualize the total ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    Barre , Create a below measure :

    Final Amount = CALCULATE([Amount Measure],ALLEXCEPT(MyTable,MyTable[OrderDate]))
     
ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Barre 

pls try right click the date column name and select the column , not date hierarchy.

Barre's avatar
Barre
Helper I
5 years ago

Thanks you for reply!

That is what I have done, and the data is shown as following.

 

OrderDate    Amount

2019-01-01     100

2019-01-01     200

2019-01-01     300

2019-01-02     200

2019-01-02     300

 

But I want the data to look like this 

OrderDate    Amount

2019-01-01     600

2019-01-02     500