Forum Discussion
Solved
Lookupvalue in 3 columns based on same date/key
Hello, i am struggeling with this issue in PowerBI. I am creating headcount tables in my company for attendance rates. i need to add value of Cell unit to employees. I have two tables, unique...
vbabka , We can create a column like
maxx(filter(Cell, (HC[ID1] =Cell[ID] || HC[ID2] =Cell[ID] || HC[ID2] =Cell[ID] ) && HC[YEAR_MONTH] =Cell[YEAR_MONTH] ) ,Cell[Cell unit])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
vbabka , We can create a column like
maxx(filter(Cell, (HC[ID1] =Cell[ID] || HC[ID2] =Cell[ID] || HC[ID2] =Cell[ID] ) && HC[YEAR_MONTH] =Cell[YEAR_MONTH] ) ,Cell[Cell unit])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Wow ! incredible - thank you a lot. what a fast answer ! you are really good
