topic Re: Convert DAX measure to create new custom column in DAX Commands and Tips

Convert DAX measure to create new custom column

Anonymous — Sat, 11 Mar 2023 22:00:03 GMT

I have a table with a column called Author which contains both employee names and manager names. I created a measure that checks another column called Employee Name to see if the names are within the Author column to produce a value of either "Employee" or "Manager" (Is the Author an Employee or a Manager?). I was able to get the results I want from the measure but in order to use that information in my analysis I need to create a new column with these values. I need help converting my DAX measure to a new custom column.

Here is my measure:

Author is Employee = IF (

CONTAINS (

VALUES ( 'GetDevelopmentGoalDetail'[Column1.Author] ),

'GetDevelopmentGoalDetail'[Column1.Author], SELECTEDVALUE ( GetDevelopmentGoalDetail[Employee Name] )

"Employee",

"Manager"

)

Here are the results that I was able to create from my measure but need those values in a new custom column.

This is dummy data so no sensitive information is shared.

Re: Convert DAX measure to create new custom column

FreemanZ — Sat, 11 Mar 2023 22:39:18 GMT

hi Anonymous

try like:

Column =

IF (

[Employee Name] IN VALUES ( data[Column1.Author] ),

"Employee",

"Manager"

)

Re: Convert DAX measure to create new custom column

tamerj1 — Sun, 12 Mar 2023 10:58:05 GMT

Hi Anonymous
Seems they are both in the same table. You can simply do

Author is Employee = IF ( 'GetDevelopmentGoalDetail'[Column1.Author] = 'GetDevelopmentGoalDetail'[Employee Name], "Employee", "Manager" )

or even

Author is Employee = IF ( 'GetDevelopmentGoalDetail'[Employee Name] = BLANK ( ), "Manager", "Employee" )

Re: Convert DAX measure to create new custom column

Anonymous — Sun, 12 Mar 2023 20:43:32 GMT

Thank you, how could your first example be modified if it was [Employee Name] is in another table? If I simply change the table name in the current solution, an error of 'A table of multiple values was supplied where a single value was expected' is thrown. tamerj1

Re: Convert DAX measure to create new custom column

tamerj1 — Mon, 13 Mar 2023 02:19:03 GMT

Anonymous

Is there a relationship between the two tables?

Re: Convert DAX measure to create new custom column

Anonymous — Mon, 13 Mar 2023 02:30:49 GMT

Yes, there is another table that has Employee Name.

Re: Convert DAX measure to create new custom column

tamerj1 — Mon, 13 Mar 2023 02:45:06 GMT

Anonymous

Yes, nut my question was: is the Employee table related to the GetDevelopmentGoalDetail table?

Re: Convert DAX measure to create new custom column

Anonymous — Mon, 13 Mar 2023 04:43:58 GMT

Yes, they both contain Employee Name.

Re: Convert DAX measure to create new custom column

tamerj1 — Mon, 13 Mar 2023 05:28:51 GMT

Anonymous
Let me be more specific. Do you have or have you created an active relationship between the two tables?

Re: Convert DAX measure to create new custom column

Anonymous — Mon, 13 Mar 2023 14:09:55 GMT

Yes. Already established.

Re: Convert DAX measure to create new custom column

tamerj1 — Mon, 13 Mar 2023 14:25:15 GMT

Anonymous

Thrn you can try

Author is Employee =
IF (
RELATED ( 'GetDevelopmentGoalDetail'[Employee Name] ) = BLANK (),
"Manager",
"Employee"
)

however, in this case I'm wondering why FreemanZ didn't work 🤔

Re: Convert DAX measure to create new custom column

Anonymous — Mon, 13 Mar 2023 15:21:35 GMT

I will mark you solution above as correct, but was curious if the column was from another table. The data is called from an API and there are some repetative datasets. Was checking to confirm accuracy of my original results. Thank you.