Replicating all days in month based on 1st day of month

[Ackbar-Learner]

Hi

I am looking at attached thread (Solved: Duplicating data for the first day of the month to... - Microsoft Power BI Community). I have the same issue but with a little bit more complication. If you look at the sample data in that thread, there is only 1 line of data per month.

How do i do the same thing in the above thread if there were more lines of data per month? I tried to do it but Power Query creates all the dates only once and i need all the dates to be replicated for each line of data. To be more specific, i need below first screenshot to become like the second one. I already have a calendar table.

[Ackbar-Learner · Accepted solution]

I was able to do this in Power query by reviewing all the steps and proceeding in a different way.

[Ackbar-Learner]

What you sent me is perfectly alright when using DAX but i need to do this in Power Query as I have several dependent steps that will come after the above is done.

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a calculated table.

New Table = 
SUMMARIZE (
    ADDCOLUMNS (
        GENERATE (
            Data,
            FILTER (
                'Calendar',
                'Calendar'[Date] > EOMONTH ( Data[Date], -1 )
                    && 'Calendar'[Date] <= EOMONTH ( Data[Date], 0 )
            )
        ),
        "@No of SKU", CALCULATE ( SUM ( Data[No of SkU] ) ) + 0
    ),
    Data[Country],
    Data[Product],
    'Calendar'[Date],
    [@No of SKU]
)

[Ackbar-Learner]

Oops i need to do this in Power Query, not using DAX.