Forum Discussion
Solved
Create calculated column for start and end date
I am working with the following two tables: Data sample table, this is showing data collected with a "stage" identifier as well as the time it was collected. Time Stage Value1 Value2 5/...
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.