Forum Discussion
Calculated column
Hi. I am new in Power Bi. Please I need to create a new column with the division between of Sum of PrecioTotal and Count of Razon.
Thanks for your help
| CodVend | Sum of PrecioTotal | Count of Razon |
| 1 | $3.57 | 2 |
| 2 | $6.90 | 3 |
| 3 | $11.23 | 3 |
| 4 | $12.26 | 3 |
| 5 | $16.84 | 4 |
Hi Anonymous,
If above sample table is the original data table in excel worksheet, you can refer to below DAX to create a calculated column.
Column = DIVIDE(Table9[Sum of PrecioTotal],Table9[Count of Razon])
If above table is the output in table visual, and the source table contains columns [CodVend], [PrecioTotal] and [Razon]. You can add below measure to table visual.
Measure=SUM(Table9[[PrecioTotal]])/SUM(Table9[Razon])
Best regards,
Yuliana Gu
4 Replies
Hi,
Paste your source data here.
Hi,
If the Table in your original post is also your source data, then write this calculated column formula
=[Sum of PrecioTotal]/[Count of Razon]
Hope this helps.
Hi Anonymous,
If above sample table is the original data table in excel worksheet, you can refer to below DAX to create a calculated column.
Column = DIVIDE(Table9[Sum of PrecioTotal],Table9[Count of Razon])
If above table is the output in table visual, and the source table contains columns [CodVend], [PrecioTotal] and [Razon]. You can add below measure to table visual.
Measure=SUM(Table9[[PrecioTotal]])/SUM(Table9[Razon])
Best regards,
Yuliana Gu
