Help with Spliweeks

[Anonymous]

Hi everyone, first time asking for help, maybe its a common answer but I'm loosing the head 😩

I have to solve split weeks for a model.  Every end of month a chunk of the week belongs to one month and another chunk belongs to the other. I have the factors involved for each, and my date table is based on fullweeks starting on saturdays.

The problem is that for each full week I have only one value but two factors.  How to split week so I can have the month value?

Hope the picture help.

@marcomartinez this is it.

[ryan_mayu]

@Anonymous 

we don't have merged cells in PBI. After you import the data, you will see some cells with null value.

1. in PQ, select example value column and fill down.

2. add a custom column

3. then you can get the expected output.