Forum Discussion
SUM
I want to summerize two colums Income - cost to profit. The colums contains filters, and it is a filer on project. Can somebody help me?
Hi Sk_an_ ,
You can create a calculated column or a measure to get profit.
Calculated column:
Profit Calculated column = [Income]-[Cost]Measure:
Profit Measure = SUM('Table'[Income])-SUM('Table'[Cost])You can learn about the difference between measures and calcualted columns from below.
Calculated Columns and Measures in DAX - SQLBI
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Sk_an_ ,
You can create a calculated column or a measure to get profit.
Calculated column:
Profit Calculated column = [Income]-[Cost]Measure:
Profit Measure = SUM('Table'[Income])-SUM('Table'[Cost])You can learn about the difference between measures and calcualted columns from below.
Calculated Columns and Measures in DAX - SQLBI
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
