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.
Community Champion
Power ParticipantThanks, 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 👍
- StuartSmith
Sorry to trouble further, but developing your solution, I want to create a final variable for the column that would check if there were any blank rows for each id that occure after the date value identified in the "RequiredByDate" and put 1 if a there was a blank row and 0 if not. So ID1 would be true as there is a blank row after row 3, but ID2 would be false. Hope that makes sence and you are able to point me in the right direction. Thanks in advance.