Forum Discussion
Power ParticipantGet column value where variable value matches another column value.
date.
you can change the type to date for the new caluclated column .
but leaving it this way also works and wont affect anything .
for the red line,
this is an intellisense bug, i guess
however you can get rid of it :
Column =var ids = table10[ID]returnSELECTCOLUMNS(FILTER(table10,table10[ID] = ids && table10[Rank] = 3),"@col" , [AbsenceDate])If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly.
Power ParticipantSo to simplfy it (as can develop it later), looking something similar to... but the below isnt working.
| ID | AbsenceDate | Name | Rank | SelectedDate | ||||
| 1 | 01/01/2024 | John Doe | 1 | 03/01/2024 | ||||
| 1 | 02/01/2024 | John Doe | 2 | 03/01/2024 | ||||
| 1 | 03/01/2024 | John Doe | 3 | 03/01/2024 | ||||
| 1 | 04/01/2024 | John Doe | 4 | 03/01/2024 | ||||
| 2 | 07/01/2024 | Jane Doe | 1 | 09/01/2024 | ||||
| 2 | 08/01/2024 | Jane Doe | 2 | 09/01/2024 | ||||
| 2 | 09/01/2024 | Jane Doe | 3 | 09/01/2024 |
Thanks
Community Champion
- StuartSmith
Thanks, that seemed to work, although before trying on my actual table, I have recreated the test table and although your code displays the correct filtered date, the code has an error (parameter is not correct type) and I dont know why. Any ideas? What data type did you have for "AbsenceDate", mine is "Date".
- Daniel29195
date.
you can change the type to date for the new caluclated column .
but leaving it this way also works and wont affect anything .
for the red line,
this is an intellisense bug, i guess
however you can get rid of it :
Column =var ids = table10[ID]returnSELECTCOLUMNS(FILTER(table10,table10[ID] = ids && table10[Rank] = 3),"@col" , [AbsenceDate])If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly.
- StuartSmith
Many thanks 👍