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

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

Datasets

Developer

Connectors

Date Time

Batch Macro

Dynamic Processing

Data Investigation

Demographic Analysis

Accepted answers

Qiu

@Amrit_Sahoo
Hope this is what you need.

New Workflow1.yxmd

All comments

Qiu

@Amrit_Sahoo
Hope this is what you need.

New Workflow1.yxmd

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. 😁

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703