Forum Discussion
Get value based on Range date time
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
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-Forum/ba-p/963216
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/1447523
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