Sum multiple columns using DAX in Power BI

0
votes

I have multiple columns containing numeric data which I would like to sum them all up in a measure.

Output would be a measure that sums all my specified columns.

Columns: STUDY LEAVE hours, Annual Leave hours, Unpaid Leave hours etc.

1
powerbidaxpowerquery

1 Answers

2
votes

You can simply do:

Total Leave Hours = SUM('Table'[Study Leave Hours]) + SUM('Table'[Annual Leave Hours]) + SUM('Table'[Unpaid Leave Hours])

Or, do a measure for each of the types of hours above (such as Total Study Leave Hours = SUM('Table'[Study Leave Hours])), and then add the 3 individual measures together:

Total Leave Hours = [Total Study Leave Hours] + [Total Annual Leave Hours] + [Total Unpaid Leave Hours]