Forum Discussion
How to make dynamic table/column, based on Username
Hi, I'm trying to create a calculated column to my table, which contains the value of another existing column, if the current user's username is contained in a third column containing the allowed...
Anonymous , USERPRINCIPALNAME() can be used in measure not column
So you can have like
maxx(table1 , IF(
CONTAINSSTRING(SELECTCOLUMNS( table1,"Allowed",[Allowed users]),USERPRINCIPALNAME())
, SELECTCOLUMNS( table1,"Szöveg",[Column1]),"access denied"
)and use in aline level visual
also, explore RLS
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
Hi Anonymous ,
Does the above reply solve the problem?
If it works, please consider to mark it as a solution.
Best Regards,
Jay