Make a new column that fills blank values with the first row of a different table

[Anonymous]

Hi all,

I am trying to make a new column in my table that needs to fill blank values with the first value of a different column. Is there a Query that can do this?

Table 1:

Column A	Column B	Column c
A1	B1
A2	B2	C2
A3	B3	C3
A4	B4
A5	B5	C5

Table 2:

Column 1	Column 2
1.1	2.1
1.2	2.2
1.3	2.3

Table 1 expectation:

Column A	Column B	Column c
A1	B1	2.1
A2	B2	C2
A3	B3	C3
A4	B4	2.1
A5	B5	C5

Or:

Column A	Column B	Column C	Column D
A1	B1		2.1
A2	B2	C2	C2
A3	B3	C3	C3
A4	B4		2.1
A5	B5	C5	C5

Can anyone help me with this situation? I am trying to DAX this.

Thanks!

[amitchandak · Accepted solution]

@Anonymous , I do not see any relation

a new column in table 1

Column D = if(isblank([Column c]), Min(Table2[Column 2]), [Column C])

[Anonymous]

Thanks! This worked