Conditional column with time range within power querry

Question

Hi togehter;&nbsp;I would like to achive the following: I have an table(table 1) with IDs and time ranges, e.g.:IDFromToABC10.10.202315.10.2023DEF05.09.202312.12.2023I have a nother table (table 2) which looks like this:IDDateABC01.01.2023ABC02.01.2023....Here(within table 2) I would like to add an additinal column which writes an X in it when the time range of table 1 matches the date and ID column in table 2; like this:IDDateMatchABC08.10.2023-ABC09.10.2023&nbsp;ABC10.10.2023XABC11.10.2023XABC12.10.2023XABC13.10.2023XABC14.10.2023XABC15.10.2023XABC16.10.2023-ABC17.10.2023-……&nbsp;Does anyone know how to achive that?Thank you and cheers, Pete!

anonymous · Accepted Answer

Hi&nbsp;Pete230&nbsp;,Please try like:
if Table.IsEmpty(Table.SelectRows(Table1,(x)=&gt;x[ID]=[ID] and [Date]&gt;=x[From] and [Date]&lt;=x[To])) then null else "X"
Output:

&nbsp;
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum&nbsp;--&nbsp;China Power BI User Group

Forum Discussion

Conditional column with time range within power querry

2 Replies

Related content

Conditional Column with Multiple Conditions

Conditional column

Conditional Column with Multiple Conditions

Conditional Column in power query

Conditional Column Creation

ID	Date	Match
ABC	08.10.2023	-
ABC	09.10.2023
ABC	10.10.2023	X
ABC	11.10.2023	X
ABC	12.10.2023	X
ABC	13.10.2023	X
ABC	14.10.2023	X
ABC	15.10.2023	X
ABC	16.10.2023	-
ABC	17.10.2023	-
…	…

ID	From	To
ABC	10.10.2023	15.10.2023
DEF	05.09.2023	12.12.2023