Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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-...
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...
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
Where does the parameter column come into the story? What is your logic for arriving at the result?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
27 | |
24 | |
13 | |
8 |
User | Count |
---|---|
74 | |
52 | |
47 | |
16 | |
12 |