Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BhavyaM
Helper V
Helper V

Date field having blanks

Hi,

 

In power BI report builder,

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

BhavyaM_1-1684952600355.png

 

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

1 REPLY 1
SamInogic
Super User
Super User

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.


Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

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

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

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.