Min Date Power Query

[Anonymous]

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] ) )

[Anonymous]

Thanks

[v-janeyg-msft · Accepted solution]

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.