Get value based on Range date time

[Wicak]

Hi all master,

i have data sample with date time 

and i have date time every 1 minute with parameter. 

so, how DAX for get data table A column sample with criteria table based on date time table B which is generating the result column table B? 

can you give me some insight About this?
Thank you for your attention

[Wicak]

hi @lbendlin thanks for reply. 

column result Table B is column Sample Table A. so If datetame table A including in range datetime B then column result have a value sample Table A

thanks

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Wicak]

thanks for intruction,

okay I will repeat the explanation

i have Table A, output value machine flexible Date time  

Date time	Value Machine
27/12/2022 23:45	1
27/12/2022 23:48	2
27/12/2022 23:58	3
28/12/2022 00:02	1
28/01/2023 00:05	1
28/01/2023 00:07	3
28/01/2023 00:10	2
28/01/2023 00:12	3

and i have table B per minute, and i want combine Table A and B where range date time table A include in Table B the copy value in range 

Example : 

date time 27/12/2022 23:58 value machine is 3,

then table B per minute copy value more than or equal date time

27/12/2022 23:58 is 3

27/12/2022 23:59 is 3

27/12/2022 00:00 is 3

until 28/12/2022 00:01 is 3

for 28/12/2022 00:02 have a value 

overall the following result

Date Time	Parameter	Result
28/01/2023 00:01	A	3
28/01/2023 00:02	A	1
28/01/2023 00:03	A	1
28/01/2023 00:04	A	1
28/01/2023 00:05	A	1
28/01/2023 00:06	A	1
28/01/2023 00:07	B	3
28/01/2023 00:08	B	3
28/01/2023 00:09	B	3
28/01/2023 00:10	B	2
28/01/2023 00:11	B	2
28/01/2023 00:12	B	3

please helpme for this problem,

because i try only used relationship and show with table. this result 

Date Time	Parameter	Result
28/01/2023 00:01	A
28/01/2023 00:02	A	1
28/01/2023 00:03	A
28/01/2023 00:04	A
28/01/2023 00:05	A	1
28/01/2023 00:06	A
28/01/2023 00:07	B	3
28/01/2023 00:08	B
28/01/2023 00:09	B
28/01/2023 00:10	B	2
28/01/2023 00:11	B
28/01/2023 00:12	B	3

thank you

[lbendlin]

Where does the parameter column come into the story?  What is your logic for arriving at the result?