In this video, Melissa will demonstrate three ways on how you can strip off seconds in a DateTime value in Power Query. DateTime values can have an extremely high cardinality, which can impact model size and performance. Ideally, we’d want to lower the cardinality of our data as much as possible while still meeting business requirements.

***** Video Details *****
00:00 Introduction
01:27 UI-driven approach
02:17 Non UI-driven approach
04:31 DateTime.ToRecord

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerQuery #PowerQueryTutorial #PowerBI #PowerBIDesktop #PowerBITutorial