Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Fellas,
Left side is my excel column,
I want to create new column in PBI to show as right table.
Thanks in advance
Solved! Go to 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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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.
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |