How to add rows in existing table for months between different start date and end date

[Anonymous]

Below is the table having emp id ,name,startdate,end date,date,month,allocation,capacity . The start date is 1st Jan 2021 and end date is 31st dec 2021 But only the allocation till June is given.For rest of the month there is no record in excel.The requirment is to showcase the allocation for rest of the month (allocation will be blank).I need to add rows for rest of the month. This is just one example We ahve many employees with different start date and end date only .How to add rows for rest of the month

Resulting date should be like,

[Anonymous]

Is there any other way to join Allocation and newly created table because left oute join is not working here

[amitchandak · Accepted solution]

@Anonymous , You can create a new tbale of measure to display. Refer the file attached for the new table approch.

A blog for measure approach

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

[Anonymous]

Thanks I was able to create the table.

table code:SUMMARIZE(filter(CROSSJOIN(Sheet1,'Date'),'Date'[Date]>=(Sheet1[startdate]) && 'Date'[Date]<=(Sheet1[end date])), [Month Year],[Month Year Sort],Sheet1[name],sheet1[empid])

But now i want to join this table with my allocation table. Emp id is the matching column in both table bt i am unable to do left outer join between table and allocation table. i am getting error "No common column joins detected".

Allocation table

 Table 

Excepted result after left outer join

Also i need to flag the rows which are newly created after left join as" new entry" and remaining rows as "old entry". New column with these values should be there.