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

Anonymous's avatar
Anonymous
Not applicable
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