user access
4 Topics
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 users' usernames, and if it doesn't, it shows a given text. So my table should look like this, if [email protected] views it: table1 column1 allowed users calculated xyz [email protected] xyz yyy [email protected] access denied The point is, I want to show the value of a column based on the allowed users column and the logged in user. My current DAX code looks like this: Calculated = IF( CONTAINSSTRING(SELECTCOLUMNS( table1,"Allowed",[Allowed users]),USERPRINCIPALNAME()) , SELECTCOLUMNS( table1,"Szöveg",[Column1]),"access denied" ) This is not working because USERPRINCIPALNAME() can't be used in calculated columns. Are there any workarounds to this problem? Many thanks!Solved2.6KViews0likes2CommentsShare content with Premium per user license
Hello, In my organization we are testing license Premium per user and we want to be sure about the sharing capabilities of it. If I have a Premium per user license and I create reports and dataflows in a Premium Workspace, to who can I share the reports generated there? I only want to share the view, the other users do not need to edit the report. As far as I checked, I can only do this with other Premium per user license users. Is there any other possiblity? Thank you!Solved13KViews0likes7Comments
