Getting previous period users and roles compared with current period users and roles with current re

[Lahari]

Hi Everyone,

i have a table in ADW which has row_load_date and based on this date users, roles and reviewers is present. I have two slicers one for current period date and other for prior period date selection. Based on the selection of date in current period and prior period my table visual should have columns of users and roles of both prior period and current period as well as reviewer of current period. Their should be conditional formatting of the table visual on the columns when compared to current period if the prior period user or role is not present then that should be highlighted. I am attaching the pbix file for the reference and I hope i will achieve positive response and solution to the problem.

I am getting expected output when their is no reviewer column in the table but when i insert the reviewer column then i am getting another output which is not what i expected. please help me to solve this problem. 

The above excel image is what i expected but getting unexpected output which is shown on right side of the table in the above image.

the above two are the pbix file images.

Please help me in solving this issue. I need the expected output in power bi desktop table visual. Thanks in advance.

[danextian]

Hi @Lahari 

I can't find a link to your pbix.

[Lahari]

I tried to insert pbix file but i am not able to insert the file. Please help me in solving this issue. Thanks for your reply.

[Lahari]

https://github.com/Lahari2808/ExcelFile.git

[danextian]

You can post a link to a pbix file stored somewhere in the cloud that can be accessed publicly.