Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙂
Solved! Go to 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])
Proud to be a Super User!
@Anonymous
does fill down in PQ work for you?
Proud to be a Super User!
Hello, I tried but it only fills null with one value I think. Maybe I did it wrong ?
@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])
Proud to be a Super User!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |