Create bridge data using start date to end date column for particular resident no

[ankita_7]

I am joining multiple tables and getting the result where there are cono,resno, date (startdate) ,enddate and admit_disch columns. I have a table that stores the result of the joins.I have attached a screenshot of the data sample for your reference. I have also attached screenshot of the query which I'm using to get this result.

I want cono,resno, date(startdate),enddate,admit_disch columns as it is but I want extra column for dates between startdate and enddate. Like as you can see in the query I have passed a date between start date and end date so may be that date not there in start or end date column but it is between the range of start and end date for a particular resno.

So how can we create a range of dates in a new column between start and enddate for that particular resno and cono. So that rows will replicate until enddate is reached for that particular resno. Then for the next resno again from start date to end date all range will be created in a newly created column and other all columns like resno cono will just be the same.

In this way I want to create a bridge data between two separate dates for that particular resno cono combination on powerbi.

Can anyone please help me with problem statement?

Thanks much in advance!

[parry2k]

@ankita_7 I would suggest to paste sample data with expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[ankita_7]

Hi,

I have posted an image along with the issue deatils. Please check the image attached with the topic.

Thanks

[parry2k]

@ankita_7if you cannot post sample data with the expected output, it is fine. Unfortunately, I don't have time to decode SQL queries in the image. I'm sure someone will able to help. Good luck!