Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

How can I get Minimum Date For each ID and Status

Hi All, I would like to get the Minimum Date for Each ID and Status, So I should be getting the  Values in COLUMN (MIN Date) in following example. What is the formula to get that. Thanks Deepak  ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    drrai66

     

    Try this

     

    =
CALCULATE (
    MIN ( Table1[Changed Date] ),
    ALLEXCEPT ( Table1, Table1[ID], Table1[Status] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

drrai66

 

Try this

 

=
CALCULATE (
    MIN ( Table1[Changed Date] ),
    ALLEXCEPT ( Table1, Table1[ID], Table1[Status] )
)
  • drrai66's avatar
    drrai66
    Icon for Resolver I rankResolver I
    8 years ago

    Thanks, It worked!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    it is measeure right how we can create column