Everything about power bi power query date-time functions

How to extract date, month, year etc in power bi?

If your selected column contains date or both date and time only then the options to work with date and time will be enabled otherwise the options will be disabled.

Now select the column(blue marked) and go to add column tab(brown marked) then go to the date option(yellow marked). In the drop-down menu of the date option,
you will see options like:
1. Age: used to calculated the age.
2. Date only: used to only get the date. Suppose you have a column containing both date and time. Now if you want only dates then just select the column and click on this option.
3. Year: used to get only year, start year or end year.
4. Month: used to get only month, start of month, end of month, days of month, name of month.
5. Quarter: used to get the quarter of year, start quarter and end quarter.
6. Week: used to get week of year, week of month, start week and end week.
7. Day: used to get day, day of week, day of year, start of day, end of day, name of day.
So to work with these options just click on the option which you want to use after selecting the column
8. Subtract date: used to subtract date. To perform this select two date columns and click on this option.
9. Earliest: used to see the earliest date. To perform this select two date columns and click on this option.
10. latest: used to see the latest date. To perform this select two date columns and click on this option.

How to extract time in power bi?

If your selected column contains time or both date and time only then the options to work with date and time will be enabled otherwise the options will be disabled.

Now select the column and go to add column tab(yellow marked) then go to the time option(yellow marked). In the drop-down menu of the date option,
you will see options like:
1. Time only: used to only get the time. Suppose you have a column containing both date and time. Now if you want only time then just select the column and click on this option.
2. Local time: used to get the Local time
3. Hour: used to get hour, start hour and end hour.
4. Minutes: used to get minutes
5. Second: used to get second.
6. Subtract: used to subtract time. To perform this select two date columns and click on this option.
7. Earliest: used to see the earliest time. To perform this select two time columns and click on this option.
8. latest: used to see the latest time. To perform this select two time columns and click on this option.
9. Combine date and time: Used to combine date and time column. To perform just select the column and click on the option.

How work with duration in power bi?

To work with duration, at first we have to get the age column from the date column using the age method present in the date option. After getting age if we select the age column then we will see that our duration option is enabled. So by using the duration column we can see the age in hours, minutes, seconds, total years, etc. To get those just select the age column and click on the option present in the drop-down menu of the duration.