Forum Discussion

DennisNilsson's avatar
DennisNilsson
Frequent Visitor
8 years ago
Solved

How do I calculate Column 1 + Column 2=?

Hey,   I have two columns, one that tells me the current number of megabytes a customer has in their space and one that tells me the number of megabytes that same customer has deleted. I am trying ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi,

     

    You can add a "New column" to the table. (tab "Modelling" --> New Column) 
    Total Uploaded Megabytes = 'yourtablename'[current megabytes] + 'yourtablename'[deleted megabytes]

     

    It will be calculated for each row. 

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Pls use this formula.

 

SUMX (Table_Name, Table_Name[Current_Megabytes]+ Table_Name[Deleted_Megabytes])

 

 

 

Thanks
Raj