Forum Discussion

RichOB's avatar
RichOB
Post Partisan
10 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
    10 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.

OktayPamuk80's avatar
OktayPamuk80
Responsive Resident
10 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.