Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
hood2media
Resolver II
Resolver II

power query to clear inconsistent strings in rows

‎11-16-2022 04:48 PM

hi,

ref to "FLT_DATE" column (column-A) in the sample file here. 

 

kindly advise on how to get rid of the time in the cells under the same column as i found that there are inconsistent i.e. some ending with "00:00" while others end with 12:00:00 AM". 

tks in advc & krgds, -nik

 

Labels:
Message 1 of 3
860 Views
0
1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

‎11-16-2022 05:45 PM 
= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})

CNENFRNL_0-1668649513064.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

Message 2 of 3
845 Views
2 REPLIES 2
CNENFRNL
Community Champion
Community Champion

‎11-16-2022 05:45 PM 
= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})

CNENFRNL_0-1668649513064.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Message 2 of 3
846 Views
hood2media
Resolver II
Resolver II
In response to CNENFRNL

‎11-16-2022 06:57 PM

many tks, @CNENFRNL .

krgds, -nik

Message 3 of 3
804 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All