Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 R...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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