IF else funtion

[Narenthir]

Hi Fellas,

Left side is my excel column,

I want to create new column in PBI to show as right table.

Thanks in advance 

[punitkhatri]

You may try creating a calculated column in power bi using this formula.

Column = IF([Excel] = "F1", "F1", "G")

Please let me know if I have answered your query.

[tackytechtom · Accepted solution]

Hi @Narenthir ,

Do you mean something like this?

newcol = if ( table[excel] = "F1", "F1", "G" )

Let me know if I understood your query correctly?

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Narenthir]

Hi @tackytechtom 
Thanks for the reply.
Actually in my PBI dataset row as F1,F2 F3,F4,F5,
I want create a new cloumn reflect as F1=F1, F2F3F4F4= G.

Hope it clears

Thanks