Forum Discussion

meklund's avatar
meklund
Frequent Visitor
5 years ago
Solved

Calc Column marking earliest dates

Hello,  Just started using DAX, powerpivot, and power BI and loving it. I'm trying to make a Calc Column for the earliest project date for each of our agents (sample data below). I imagine it lo...
Calculated columns
DAX
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You should probably do this as a measure instead but it is common for people new to Power BI to overuse calculated columns.  Here is a column expression to get your result, but it would work as a measure too (in a table visual with the AgentCode column).

     

    First Project Date = CALCULATE(MIN(Table[ProjectDate]), ALLEXCEPT(Table, Table[AgentCode]))

     

    Regards,

    Pat

     

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You should probably do this as a measure instead but it is common for people new to Power BI to overuse calculated columns.  Here is a column expression to get your result, but it would work as a measure too (in a table visual with the AgentCode column).

 

First Project Date = CALCULATE(MIN(Table[ProjectDate]), ALLEXCEPT(Table, Table[AgentCode]))

 

Regards,

Pat