Sum Formula Help

[erhan_79]

Hi there ;

I have a table as below whic named "Table A " , and for this table i need to calculate based on status totals and create a new table or maybe witch measure 

could you pls help about the formula 

[amitchandak · Accepted solution]

@erhan_79 , if you simply pot then in table visual and take sum(Table[Amout]) This will work.

If you need a new data table , use new table option, and the following script

New table =summarize(Table, Table[date], Table[Status] ,"Amount", sum(Table[Amout]))