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
Solved! Go to Solution.
= 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! |
= 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! |
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
76 | |
65 | |
53 | |
51 |
User | Count |
---|---|
183 | |
101 | |
80 | |
79 | |
77 |