Forum Discussion
Help with formula please
Hi Anonymous
The Greg_Deckler solution will 100% cover your request; Just remove that Bracket ) at the end.
and if you want to replace "null" with blank use this:
if [Job Family] = "Direct Sales" and Text.Contains([Job Title] , "Account Executive") then "AE" else ""If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Community ChampionAnonymous You are trying to use DAX in Power Query and that is not going to work out very well for you. You need to do this in a calculated column in Power BI Desktop, not Power Query Editor. Or you need the M equivalent which is something along the lines of:
if [Job Family] = "Direct Sales" and Text.Contains([Job Title],"Account Executive")then "AE" else null)
Super UserHi Anonymous
The Greg_Deckler solution will 100% cover your request; Just remove that Bracket ) at the end.
and if you want to replace "null" with blank use this:
if [Job Family] = "Direct Sales" and Text.Contains([Job Title] , "Account Executive") then "AE" else ""
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
- Greg_Deckler
VahidDM Thanks, missed that paren!!