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.

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

Hi RichOB 

We’d like to confirm whether your query has been addressed. If you still need help, please let us know and we’ll provide further guidance.

 

  • 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