Forum Discussion

jlarques's avatar
jlarques
Helper V
2 years ago

Create a table with new rows

Dear community, I have another challenge to overcome.   I have two tables:  Payroll table with pay date of each employee Project table with start and end date and  % project attribution of each...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

jlarques , You can do have additional row using

 

Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

 

Measure way

Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

 

Better the HR Way

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

  • jlarques's avatar
    jlarques
    Helper V
    2 years ago

    amitchandak 

    thanks for your answer. 

     

    Let me review all your information and I'll tell you if I can do it or not. 

     

    Thanks again for your help.

     

     

  • jlarques's avatar
    jlarques
    Helper V
    2 years ago

    Hi amitchandak ,

    apologies for my delay's answer.

    I watched your videos and I understood you can do it, but I don't how to add rows with the specific problem that I have, because you're using measures and it's complicated for me translate it to a tables.

     

    Thanks for your help.