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.
Hey kurtsmetana, it seems you want to filter one table's data based on the currently logged-in user's email ID in both Power BI Desktop and Service, but RLS is not suited to your requirement.
you can use this and let me know if there is any problem.
Measure = CALCULATE (IF ( MIN ( 'AssignmentTimephasedDataSet'[ResourcesOwner.ResourceEmailAddress] )= USERNAME (),1,0))