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

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

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

Phil_Seamark,

 

Thanks for your suggestion. It works. Awesome.