Forum Discussion
Get value based on Range date time
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
4 Replies
Where does the parameter column come into the story? What is your logic for arriving at the result?
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/1447523thanks 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
