Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everyone, i have a basic question regarding m language. What will be best way to practice it? And i have a column where in few cells "Aop" is mentioned in remarks and others are not. I want to add a new column and add this word Aop if that is in earlier column or else null. How to do that?
Solved! Go to Solution.
Hi @Rafi35
Best way to practice:
Try this code using custom column:
if Text.Contains([Column Name], "Aop") then "Aop" else null
Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
Hi @Rafi35
Best way to practice:
Try this code using custom column:
if Text.Contains([Column Name], "Aop") then "Aop" else null
Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
Check out the July 2025 Power BI update to learn about new features.