Date only or Time only

[lastnn30]

Hi 

I have a column which has the date and time. I want to have date only or time only. In power Query, I see that can be achived using 2 ways? Which on is the correct one? Please see screenshot below:

[Mahesh0016 · Accepted solution]

@lastnn30  Good Morning,

>> you should go with First screen Shot Way it is better.

**If this post helps, please consider accept as solution! Appreciate your Kudos !! to help other members find it more quickly.

[Anonymous · Accepted solution]

Hi  @lastnn30 ,

In the first screenshot, you can follow the functions provided above to find the year, month, and day of different conditions.

For example, Year: Year – Start Year -- End of Year.

If you want to format Date and Time directly, you can use the second one directly

Right-click the column – Change Date – Date/Time

Refer to:

Power BI Date Formatting | How to Change Date Format in Power BI? (wallstreetmojo.com)

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mahesh0016 · Accepted solution]

@lastnn30  Good Morning,

>> you should go with First screen Shot Way it is better.

**If this post helps, please consider accept as solution! Appreciate your Kudos !! to help other members find it more quickly.