Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.