Forum Discussion

3lj's avatar
3lj
Frequent Visitor
4 years ago
Solved

DAX ? How to extract a value from another table based the value of multiple columns in that table?

Hi All,   Thank you in advance for any help anyone can offer, I'm currently going round in circles trying to find the right solution here. I think I need to use DAX, and i've been playing around w...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi 3lj ,

     

    If you want a calculated column, please try.

    Start Date = 
VAR _table =
    RELATEDTABLE ( 'Projects' )
VAR _mindate =
    CALCULATE ( MIN ( 'Tasks'[Stage Complete] ), _table )
RETURN
    _mindate
    End Date = 
VAR _table =
    RELATEDTABLE ( 'Projects' )
VAR _maxdate =
    CALCULATE ( MAX ( 'Tasks'[Stage Complete] ), _table )
RETURN
    _maxdate

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

3lj , Seem like they are min and max date

 

Start = Min(Table[Stage Complete])

 

or minx(filter(Table, Table[Stage] = "Stage 1" ), Table[Stage Complete])

 

For End

end =

Max(Table[Stage Complete])

 

or Maxx(filter(Table, Table[Stage] = "Stage 4" ), Table[Stage Complete])

 

 

  • 3lj's avatar
    3lj
    Frequent Visitor
    4 years ago

    Yeah, there might be other stages added later, so I'm going to try the second option, which specifcally says "Stage 1".

     

    Although, forgive me, if I don't see it, how does this take into account / filter based on "project a" or "project b"? (i.e. the current "'row" of the Projects Table?). That's what I'm conceptually struggling with 😞

    (as wouldn't it find the "first" start date of all of the projects?, not just the project of the current row?)
    Thank you for your help and assistance!