Sum payment based on each day

[JulietZhu]

I need sum payment for each day. For example 20170905 has two payments and I need total for that day of (3567.16+176.68)= 3743.84. Need help for Dax? Tryied so many  and still can't figure it out. Thanks

[Phil_Seamark]

Hi @JulietZhu

If you drag the Date field to a Table visual, then drag the Payment_Amt, it should automatically sum the Payment_Amt

If you are trying to create a table that summarizes this data, you could try the following calculated table

Table = SUMMARIZECOLUMNS(
                    'Table1'[date],
                    "Sum of Amount",SUM('Table1'[Payment_Amt])
                    )

[JulietZhu]

hi @Phil_Seamark

Yes. PowerBI will automatically sum based on day if changing to table visual.

I do need create this table for other calculated columns. I tried your formula, but got the following error message. Can't figure out why? Thanks

[Phil_Seamark · Accepted solution]

Hi @JulietZhu

You need to create a calculated table rather than a calculated measure. Click on the [new table] button on the modelling tab and then paste in your code.

 Let me know how you go 🙂

[JulietZhu]

@Phil_Seamark,

Thanks for your suggestion. It works. Awesome.