Forum Discussion
Kumarun
4 years agoHelper I
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
- amitchandakSuper User
Kumarun , a new column
If(not(isblank([project])), [project], maxx(filter(Table, Table[emp Id]=1),[project] ) )
- KumarunHelper I
Thank you