Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
3 years ago
Solved

Finding Minimum date

Hello all, Please find the attached. I need to find the minimum snapshot date as highlighed below. A,B,D projects are showing correct minmum date but C & E is not showing correctly. I am adding the ...
Need Help
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    Hi harshagraj ,

     

    MinOfSnapDate =
CALCULATE (
    MIN ( 'Table (2)'[snap_date] ),
    FILTER (
        ALLSELECTED ( 'Table (2)' ),
        'Table (2)'[project_number] = SELECTEDVALUE ( 'Table (2)'[project_number] )
    )
)

     

    If I helped, Accept it as a solution.

    Regards,

    Loran

MohammadLoran25's avatar
MohammadLoran25
Solution Sage
3 years ago

Hi harshagraj ,

 

MinOfSnapDate =
CALCULATE (
    MIN ( 'Table (2)'[snap_date] ),
    FILTER (
        ALLSELECTED ( 'Table (2)' ),
        'Table (2)'[project_number] = SELECTEDVALUE ( 'Table (2)'[project_number] )
    )
)

 

If I helped, Accept it as a solution.

Regards,

Loran