Create dynamic Date Slicer

[goncalogeraldes]

Hello there community!

I have checked a few threads and seen similar questions but I would like to expose my doubt anyhow.

I have a table with sales data for multiple users (Power BI tenants) with RLS implemented so that each user only has access to its data. I would like to create a dynamic date table that can interact with the user filter so that the calendar "changes" depending on the user that is using the report.

For example, if user A has a MIN(date) = 1/1/2019 and MAX(date) = 31/12/2020, the calendar would be between 2019 and 2020 but if I changed to user B, which has a MIN(date) = 1/1/2010 and MAX(date) = 31/12/2015, the calendar would be between 2010 and 2015. I have tried multiple workarounds (DAX and Power Query) but I cannot create a usable solution. The goal is to avoid having excess empty dates for each user.

Can anyone give me some advice/solution?

Thanks in advance for any help provided! 🙂

[amitchandak]

@goncalogeraldes , As far as I know, userprincipalname can be used in measure or RLS roles, So I can doubt you can create such a table

[goncalogeraldes]

So will the userprincipalname filter the dates table?

[amitchandak]

@goncalogeraldes , No you can not use it in the creation of the table. That is what I think