how to derive date rows from the dates and distribute the value

[Amrit_Sahoo]

Hello Guys,

I need one help with a table transformation where I have the 1st date of the month and projected sales for the entire month. I would need to generate the remaining dates for each month and divide the projected sales for each day after excluding the weekends.

Please help me here

[Qiu · Accepted solution]

@Amrit_Sahoo 
Hope this is what you need.

[Amrit_Sahoo]

Hi @Qiu, Thanks a lot for the help. This solution is required but I was also need dates as well.However going by your methodology I have found the solution. Thank you so much. Really appreciated!!

[Qiu]

@Amrit_Sahoo 
Glad to help and thank you also for the accept mark. 😁