Forum Discussion

Kumarun's avatar
Kumarun
Helper I
4 years ago
Solved

Dax

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.

  • Kumarun , a new column

     

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

2 Replies