Forum Discussion
evalromf
Helper I
Helper IAND IF in conditional column
Hi, I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns. What I'm looking for is something like this: If [COUNT...
GilbertQ
Super User
Super UserHi there
I would suggest instead of using a calculated column in the data model, do this in the Power Query Editor where you can use the Custom Column, where you can use multiple conditions.
here is my blog post explaining this: https://www.fourmoo.com/2018/11/27/multiple-conditions-for-a-conditional-column-in-power-query/
I would suggest instead of using a calculated column in the data model, do this in the Power Query Editor where you can use the Custom Column, where you can use multiple conditions.
here is my blog post explaining this: https://www.fourmoo.com/2018/11/27/multiple-conditions-for-a-conditional-column-in-power-query/
PowerBIBeginer
Helper V
Helper VHi,
On your solution, it is not written how to get custom column. I got it now, its difficult me to find that. Okk..
As now im trying in custom column, how do i mentioned this line-
IF[Cond1]="abc" and INT(24*[TAT excluding weekends_holidays])>8, then ">8Hrs" else if ...
INT(24*[TAT excluding weekends_holidays])>8 ??
Can i use INT above? Or directly like
IF[cond1]="abc" and 24*[TAT excluding weekends_holidays])>8 then ">8Hrs" else if ...