Create new table between dates, use an item multiply times

[csuvarszkia]

Hello,

I have a table with start date, deadline date and end date columns. (date_table)
I would like to create a new table, show me row by row: from start to item closed before deadline or exceeded the deadline.
But the difficulty is, I would like to list it by date into months.

Is there a solution using a loop?

Thanks

[V-lianl-msft]

Hi @csuvarszkia ,

I'm also working on this kind of problem. The only thing I can do is to get the start and end time of each ID, then Union several tables, and then create a new calculated column with the switch function or if function. But it's not intelligent at all.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

This gives us how to get all dates between the start and end. You can develop logic for 3rd one.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin