Forum Discussion
Solved
Custom column based on existing columns
I want to add a custom column, after loading an Excel file to Power BI, so that I can define a number of IF conditions, which depend on existing columns. (For example: if "Employee number greater th...
RafaelAri , In DAX you can use Switch or if, power query you can use if then else
if([employee number] > 50 && containsstring([employee name], "ABC" ) && [Work Start Date] > date(2022,1,1) ,1 ,0 )
You can try Search or find too
SEARCH and FIND: https://www.youtube.com/watch?v=mZt0HJw4gjQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=45
Thanks Steve