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))   Th...
  • 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

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