Earliest date and Latest date option disable to for me in Power Query Add column option

[Analystmate]

Hi All,

The Earliest Date and Latest Date options are disabled for me in the Power Query Add Column option.

I have selected date coulmn with proprer date data type .

Please help me figure out what possible reasons could be causing this issue.

[zenisekd · Accepted solution]

Hi, it can be used only when you select multiple columns. It returns the earliest day from the columns selection per row. 

Kudos and mark as solution appreciated.

[collinsg · Accepted solution]

Hello Analystmate,

zenisekd has given the reason. Here is a way to add a column containing the earliest date in column "Date".

= Table.AddColumn(PreviousStep, "Earliest Date", each List.Min( PreviousStep[Date] ), type date)

Insert the step, substituting "PreviousStep" with the name of your previous step and substituting "[Date]" with the name of your date column in square brackets.

Hope this helps.

[zenisekd · Accepted solution]

Hi, it can be used only when you select multiple columns. It returns the earliest day from the columns selection per row. 

Kudos and mark as solution appreciated.