Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Min Date Power Query

Hi Experts

 

How could i calcaulte the Mini date in Power Query.... Currently i am doing a calculated column 

= calculate(MIN( BIvw_Lead[Date] ), ALLEXCEPT( BIvw_Lead, BIvw_Lead[BIvw_Reservation.crimson_name] ) )
 
 
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    You can create a custom column in PQ.

    Like this:

    List.Min(Table.SelectRows(#"Changed Type",(x)=>x[name]=[name])[date])

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    You can create a custom column in PQ.

    Like this:

    List.Min(Table.SelectRows(#"Changed Type",(x)=>x[name]=[name])[date])

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.