Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am working with the following two tables:
Time | Stage | Value1 | Value2 |
5/22/2020 13:01:15 | 1 | ||
5/22/2020 13:02:15 | 1 | ||
5/22/2020 13:03:15 | 1 | ||
5/22/2020 14:01:15 | 2 | ||
5/22/2020 14:02:15 | 2 |
Stage | Start | End |
1 | 5/22/2020 13:01:15 | 5/22/2020 13:03:15 |
2 | 5/22/2020 14:01:15 | 5/22/2020 14:02:15 |
These tables are realted via stage number. For table 2, where I am having issues is calculating the Start and End Time. For start time, it needs to filter data 1 by corresponding stage and find the first time.
I have tried the following DAX expression, but am getting odd results:
Start = CALCULATE(FIRSTDATE(ParameterValues[date].[Date]),USERELATIONSHIP(ParameterValues[stageId],Stages[_id]))
Every row is returning 1/1/2020 12:00:00 AM for start and 12/31/2020 12:00:00 AM for end, but neither of these values are in the table.
Im sure I am making a simple mistake, but have been stuck and cannot get it figured out. Thank you in advance for the help!!
Solved! Go to Solution.
@att9728 , Not very clear, Both as a new column in table 2
start Time table 2 = minx(filter(table1,table1[Stage] =table2[Stage]),table1[Time])
End Time table 2 = maxx(filter(table1,table1[Stage] =table2[Stage]),table1[Time])
@att9728 , Not very clear, Both as a new column in table 2
start Time table 2 = minx(filter(table1,table1[Stage] =table2[Stage]),table1[Time])
End Time table 2 = maxx(filter(table1,table1[Stage] =table2[Stage]),table1[Time])
Thank you for this! This is the answer.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |