Forum Discussion

Shee_powerbi's avatar
Shee_powerbi
Frequent Visitor
3 years ago

Flatten the rows based on common id

Hi, I am trying to create a table based on roles that employee has as per the excel file. Eg - 

Emp EmailIDEmp IDMarketRegionCountryArea
[email protected]WERQWWGER SWERL
[email protected]WERFQ ERLABZEWD
[email protected]WERFQ WDER AU 
[email protected]WERDQ EDER ERNANYERZ

Power Bi data

Emp IDMarketRegionCountryArea
WERQWWGER EWDFSWERL
WERFQ WQSDERLABZEWD
WERFQ WDERERFG AU EGH
WERDQ EDER ERNANYERZ
WERDQEWTH ERNONJERS

 

I need to match the employee roles in excel with those in power bi and create a table in power bi to add RLS using email id in the report. How do i flatten the table. Please help. 

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi  Shee_powerbi 

    >> to create a table based on roles

    it is not clear, please provide the expected output in table format, thanks

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.