Calculated column

[Anonymous]

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

[v-yulgu-msft · Accepted solution]

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

[Ashish_Mathur]

Hi,

Paste your source data here.

[Anonymous]

My source data is a excel spreadsheet.

The table of the message is the data of that spreadsheet.

Thanks for your help

[Ashish_Mathur]

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.