Values Which are Preceding those to be shown in next cell using Power BI desktop

[Anonymous]

Hi , 

We need help in below scenario , if anyone knows the answers its really appreciated for us. 

Table A having below column 1st with below values.

Column 1st

1
2
3
4
5
6
7
8
9
10

Table B having below columns with values 

Column 1stColumn 2nd

1	100
2	150
5	175
8	200

Table C once left join between both abve tables 

Column 1st	Column 2nd
1	100
2	150
3
4
5	175
6
7
8	200
9
10

But i want output like this using Power BI desktop DAX 

e,g aove table if checked for 3 and 4 there is empty but i want values which preceds.

Column 1st	Column 2nd
1	100
2	150
3	150
4	150
5	175
6	175
7	175
8	200
9	200
10	200

[Pragati11]

Hi @Anonymous ,

You can create a new column in your 3rd table as follows:

corrected value =

VAR PreviousRow =

CALCULATE(

MAX('Value Data'[Value]),

FILTER ( 'Value Data', 'Value Data'[Id] < EARLIER ( 'Value Data'[Id] ) )

)

RETURN IF('Value Data'[Value] = BLANK(), PreviousRow, 'Value Data'[Value])

Replace Value Data'[Id]  with Column 1st

Replace Value Data'[Value] with Column 2nd

The output on my test data is a s follows:

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Greg_Deckler]

 Use Fill Down?

[Anonymous · Accepted solution]

Thanks I have found the solution , 

As fill option in transform at Power BI desktop