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 Amount per day, and not show all datapoints per each day. The OrderDate hierarchy needs to be off in the table.

 

Sample data

OrderDate    Amount

2019-01-01     100

2019-01-01     200

2019-01-01     300

2019-01-02     200

2019-01-02     300

 

How I want the table to show the values

OrderDate    Amount

2019-01-01     600

2019-01-02     500

  • Barre , Create a below measure :

    Final Amount = CALCULATE([Amount Measure],ALLEXCEPT(MyTable,MyTable[OrderDate]))