Forum Discussion

pepito's avatar
pepito
Frequent Visitor
8 years ago
Solved

Operation with column

Hello comunity,

Neebie in power BI , i'm trying to make a table frome request.

 

is it possible to make operation like column1/column2  like it's possible in qlikview (=Column(5)/Column(2))

 

Thank you

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi pepito,

     

     

    Power bi not contains row index and column index, you need to use column name to calculate with specific columns.

     

    Calculate column formula:

    Result =
Table[Column5 Name] / Table[Column2 Name]

     

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi pepito,

     

     

    Power bi not contains row index and column index, you need to use column name to calculate with specific columns.

     

    Calculate column formula:

    Result =
Table[Column5 Name] / Table[Column2 Name]

     

    Regards,

    Xiaoxin Sheng