Forum Discussion

RichOB's avatar
RichOB
Post Partisan
11 months ago
Solved

Adding new columns from data

Hi, I have a data table that tracks employees who have left my company and then returned. I need the Date data when they have returned on the same row, as their singular NI_Number, please. How can I ...
Need Help
  • OktayPamuk80's avatar
    OktayPamuk80
    11 months ago

    Hi,

    I would create an index per Ni_Number (e.g. Solved: Index column based on value/category - Microsoft Fabric Community). With this index you can then create a matrix, where the index is your column, therefore in case of three entries per Ni-Number you would see 3 columns (or 9 due to three measures joined. left and employed).

    Regards,

    Oktay

     

    If it helped you would appreciate a KUDOS and mark the answer as solution.

v-aatheeque's avatar
v-aatheeque
Community Support
10 months ago

Hi RichOB 

Have you had a chance to look at the earlier response? Let us know if anything is unclear, and we’ll provide further clarification.

v-aatheeque's avatar
v-aatheeque
Community Support
10 months ago

Hi RichOB 
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know