Forum Discussion

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
3 years ago
Solved

Lookup returning value with earliest & latest date

Hi folks, I am trying to calculate case duration (1 case consists of several tasks) and I amhaving issue with lookup function that should return the value with earlierst and also latest date. Exampl...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    IvanS , new columns

    Case start = minx(filter(Fact, Case_id = earlier([Case ID]) , [Created Date])

     

    Case Closed= Maxx(filter(Fact, Case_id = earlier([Case ID]) , [Close Date])

     

    Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

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

IvanS , new columns

Case start = minx(filter(Fact, Case_id = earlier([Case ID]) , [Created Date])

 

Case Closed= Maxx(filter(Fact, Case_id = earlier([Case ID]) , [Close Date])

 

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
3 years ago

Thank you for prompt help. Worked like a charm! 🙂