Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional columns

Hi,   I have a table with monthly company data for 3 years. I am trying to reshape my table and make new columns for some of the metrics using conditional columns. My table looks like below:   ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , first table when you create columns, Second table is when you create a measure.

Even if you create column, when you show on visual, it will group like second table

 

new columns 

revenue= if([Metric name] ="Revenue",[Metric Value], blank())

 

Cost= if([Metric name] ="Cost",[Metric Value], blank())

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    Sorry, I am new to Power BI, do you mean that I should make a "custom column"? In that case, I get an error related to the [metric value].

     

    Thanks.