Forum Discussion

ncbf87's avatar
ncbf87
Frequent Visitor
4 years ago

[Issue] Dynamic RLS using Org Hierarchy but over last 24 months

Hi all,   I've built a dynamic RLS for Org Hierarchy (HR Data) based on RADACAD's post It's all looking good and working fine IF leaders are looking at current data based on current structure. How...
Need Help
ncbf87's avatar
ncbf87
Frequent Visitor
4 years ago

Thanks amitchandak ,

While you're right it's a type 2 SCD, is there an easier way to workaround the RLS where it uses the department/org hierarchy as reference?

i.e. if User A is a leader in Sales, only filter (RLS) and show data from Sales function in the last 24 months

 

My current RLS DAX formula in Manage Role is

PATHCONTAINS(User[Path],
MaxX(
Filter(
User,
[Email]=USERPRINCIPALNAME()
)
,User[ID]
)
)

Wonder if there's any tweak to include an "IF" statement there per my logic above?