Forum Discussion
OS user
HI Anonymous ,
Try using USERNAME dax function in Power BI.
you can refer following link for details:
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Anonymous
CONCATENATE only works for 2 objects. You need multiple CONCATENATE and Format().
Access = CONCATENATE("Confidential: Data accessed ", CONCATENATE(USERNAME(), CONCATENATE(FORMAT(NOW(),"YYYY/MM/DD HH:MM:SS"),"is responsible for keeping this data secure.")Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Create this measure:
Measure = CONCATENATE(USERNAME(),NOW())
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi im getting error while using this. could you please help how to avoid this?
whats wrong in this measure
Access= CONCATENATE(" Confidential: Data accessed",USERNAME(),NOW(),"is responsible for keeping this data secure.")i want to show this date foramt Date(Now(),'YYYY-MM-DD HH:MM:SS'
Anonymous
CONCATENATE only works for 2 objects. You need multiple CONCATENATE and Format().
Access = CONCATENATE("Confidential: Data accessed ", CONCATENATE(USERNAME(), CONCATENATE(FORMAT(NOW(),"YYYY/MM/DD HH:MM:SS"),"is responsible for keeping this data secure.")Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.