Dax

[Kumarun]

Hi Guys,

I have the employee's id and project, employee 1 has some projects, but employee 2 is empty.

whatever projects employee one has, they should also reflect on employee two.

like this:

emp id  project
1           A
1           A
2           A
2           A

suggest me on this .

Thnak you.

[amitchandak · Accepted solution]

@Kumarun , a new column

If(not(isblank([project])), [project], maxx(filter(Table, Table[emp Id]=1),[project] ) )

[Kumarun]

Thank you