Solved: power query to clear inconsistent strings in rows

hood2media · ‎11-16-2022

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

CNENFRNL · ‎11-16-2022

= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})

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

CNENFRNL · ‎11-16-2022

= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})

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!

hood2media · ‎11-16-2022

many tks, @CNENFRNL .

krgds, -nik

power query to clear inconsistent strings in rows

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

How to Get Your Question Answered Quickly