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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Paste your source data here.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

My source data is a excel spreadsheet.

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

Thanks for your help

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    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.