Forum Discussion

Barre's avatar
Barre
Icon for Helper I rankHelper 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
Icon for Super User rankSuper User
5 years ago

Barre 

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

  • Barre's avatar
    Barre
    Icon for Helper I rankHelper 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