Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi team,
I need to fill the current blanks values with previous row data.
I tried but able to find the solution.Can you please try to give Solution.
Colulmn1
A
null
null
B
null
null
Expected Result
Column
A
A
A
B
B
B
Thanks,
Solved! Go to Solution.
Hi @Sushmach109,
Add an index column first.
Create a calculated column with below DAX formula.
Required Result = IF ( Table_1[Column2] = BLANK (), CALCULATE ( LASTNONBLANK ( Table_1[Column2], 1 ), FILTER ( Table_1, Table_1[Index] < EARLIER ( Table_1[Index] ) ) ), Table_1[Column2] )
Best regards,
Yuliana Gu
Hi @Sushmach109,
Add an index column first.
Create a calculated column with below DAX formula.
Required Result = IF ( Table_1[Column2] = BLANK (), CALCULATE ( LASTNONBLANK ( Table_1[Column2], 1 ), FILTER ( Table_1, Table_1[Index] < EARLIER ( Table_1[Index] ) ) ), Table_1[Column2] )
Best regards,
Yuliana Gu
Thanku.
@Sushmach109 you can use the fill down function in query editor
go to the transform menu on the ribbon and select fill and then down
Proud to be a Super User!
This is very dynamic and is not one time transformation.
What is equalent dax formula for this?
Column1 Column2 Required Result
ticket1 A A
ticket1 null A
ticket1 null A
ticket2 B B
ticket2 null B
ticket2 null B
ticket2 C C
ticket2 null C
Thanks,
@Sushmach109 the solution i posted is dynamic, whatever data is loaded will have that applied to it everytime
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |