Forum Discussion

JulietZhu's avatar
JulietZhu
Icon for Helper IV rankHelper IV
8 years ago
Solved

Sum payment based on each day

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

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

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

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      JulietZhu
      Icon for Helper IV rankHelper IV
      8 years ago

      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's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

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