Forum Discussion
Last Modified Date vs all Customers with the same Last Modified Date
I have data with a customer list and last modified date. I want to create something, a slicer, or chiclet, tht when a customer opens the dashboard it will reflect their last modified date and only th...
Do you have a Modified Date column in your table? In that case, you can use Username() function to get the records which for current customer, and then get the MAX modified date. Then you can use this date to filter data. Pease refer to the link below to see how to use Username() function in role levle security.
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
Regards,
Charlie Liao