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 Supplier
Solution Supplier

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

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.