Forum Discussion

BhavyaM's avatar
BhavyaM
Icon for Helper V rankHelper V
3 years ago

Date field having blanks

Hi,   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 forma...
Need Help
SamInogic's avatar
SamInogic
Icon for Super User rankSuper User
3 years ago

Hi BhavyaM ,

 

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

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

 

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.

 

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


Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/