Dynamic Month and Conditional Rows

[Anonymous]

Hello I'm stuck at data transforming level. In this first example of my data, I added the company's untransformed data example. 

Name parts should be filled, but only the first line is filled and the other lines come empty from the source.

But Company needs it this this way.

 This is the data from my source.I need to fill the blank values in names dynamically. 

For example fill "A" to type from first Row A to First Row B. I tried to show the expected 

Data will come again in the form of weeks of the month (when I am in next month). It can come as 5 weeks in the next month.

How can I do this dynamically ? 

Thank your for your time and helps 🙂

[ryan_mayu]

@Anonymous 

does fill down in PQ work for you?

[Anonymous]

Hello, I tried but it only fills null with one value I think. Maybe I did it wrong ?

[ryan_mayu · Accepted solution]

@Anonymous 

Sry, you are correct. I think there maybe some way we can do that in M, however, I am not good at it.

Here is a workaround, create an index column and create another column

New name = 
VAR INDEX=maxx(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[name]<>""),'Table'[Index])
RETURN 
IF('Table'[name]="",MAXX(FILTER(ALL('Table'),'Table'[Index]=INDEX),'Table'[name]),'Table'[name])