Forum Discussion

ShocKrates's avatar
ShocKrates
New Member
1 year ago
Solved

Calculated Column that evaluates multiple rows

I have a table like the one below: Project ID Spend Date First Spend Month 1 1/1/2024 1/1/2024 1 2/2/2024 1/1/2024 2 5/1/2024 5/1/2024 2 8/1/2024 5/1/2024   Columns 1...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, ShocKrates 

    Thanks for gmsamborn's concern about this issue.

     

    I am glad to help you.

     

    You can refer to my DAX to New Column:

    First Spend Month = 
CALCULATE(
    MIN('Table1'[Spend Date]),
    ALLEXCEPT('Table1', 'Table1'[Project ID])
)

    Or

    First Spend Month = 
VAR CurrentProjectID = 'Table1'[Project ID]
RETURN
CALCULATE(
    MIN('Table1'[Spend Date]),
    FILTER(
        'Table1',
        'Table1'[Project ID] = CurrentProjectID
    )
)

     

    This is test result:

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gmsamborn's avatar
gmsamborn
Super User
1 year ago

Hi ShocKrates 

 

Would a column like this help?

 

_Result = 
VAR _Proj = [Project ID]
RETURN
    CALCULATE(
        MIN( 'Table'[Spend Date] ),
        ALL( 'Table'[Spend Date] ),
        'Table'[Project ID] = _Proj
    )

 

 

Let me know if you have any questions.