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.c...
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.

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.