Forum Discussion
Solved
USERPRINCIPALNAME in Column
Hello we are recieving below error. Based on the userprincipalname, we want to change the value of a column. Any ideas? CUSTOMDATA, USERNAME, USERCULTURE and USERPRINCIPALNAME functions are not...
kurtsmetana Columns are not dynamic, they are calculated at the time of data load. Thus, you cannot use those functions in columns, only measures.
try this in a measure Assuming you have a table called UserData with columns like Username and Value. You want to filter or adjust the Value column based on the current user’s USERPRINCIPALNAME
Filtered Value =
VAR CurrentUser = USERPRINCIPALNAME()
RETURN
CALCULATE(
SUM(UserData[Value]),
UserData[Username] = CurrentUser
)