Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX New Column and Substitute

Hi All I am trying to understand how to create a new column from one table to within another table and replace any blanks within the new column with "No Record" text. The following does not replace...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    You can try a calculated column as follows:

    UPN = IF(RELATED(users[userPrincipalName]) = BLANK(), "No Record", RELATED(users[userPrincipalName]))

     

    Thanks,

    Pragati

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Pragati11 

Yes. Your solution worked for me.

I also, worked out the following solution...

UPN =
VAR UPNList = RELATED(users[userPrincipalName])
RETURN
IF(UPNList = "", "No Record", UPNList)