Date only or Time only

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.

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.