Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Date field having blanks



In power BI report builder,

I have a column with "start date" but having Blank rows as well. 



how to convert it in to date and time from "text to "Date" data type into 24 hrs formate like "yyyy-mm-dd HH:mm:ss" and How to take max date from the date field


please help

Solution Sage
Solution Sage

Hi @BhavyaM ,


It seems that you have a table with date values as shown in below screenshot,

Forum 01.png

You can change the format for column using format option as shown in the below screenshot,


Forum 02.png

Also, to get a Max date from all dates you can create a measure using below DAX expression,


Max Date = MAX(DateTable[Dates])


This will give you max date from all dates from the table. Please refer to the below screenshot for the same.

Forum 03.png


If this answer helps, please mark it as an Accepted Solution so it would help others to find the solution.


Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at


Power Platform/Dynamics 365 CRM Tips and Tricks:

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Kudoed Authors