Forum Discussion

YonaD's avatar
YonaD
Frequent Visitor
4 years ago
Solved

Calculated Column or New measure

Hello Everyone, I am new to power BI and DAX and I was trying to create a calculated column in which the values depend on the calculation from another table. My data look like these: Table 1 P...
  • amitchandak's avatar
    amitchandak
    4 years ago

    YonaD , a new column

     

    new column in table 2 =
    datediff(minx(filter(Table1, Table1[Project ID] = Table2[Project ID] && Table1[Activity] ="Task 1"),Table1[Start Date]),
    maxx(filter(Table1, Table1[Project ID] = Table2[Project ID] && Table1[Activity] ="Task 2"),Table1[Finish Date]),day)

amitchandak's avatar
amitchandak
Super User
4 years ago

YonaD , a new column

 

new column in table 2 =
datediff(minx(filter(Table1, Table1[Project ID] = Table2[Project ID] && Table1[Activity] ="Task 1"),Table1[Start Date]),
maxx(filter(Table1, Table1[Project ID] = Table2[Project ID] && Table1[Activity] ="Task 2"),Table1[Finish Date]),day)

YonaD's avatar
YonaD
Frequent Visitor
4 years ago

Thank you so much!