Hello Power Excellers. In this blog post, I want to share with you two ways to convert dates in Excel Power Query. Why are there multiple ways?. Well one of them uses and Menus available on more recent versions of Power Query and one uses the Date.ToText function. (A Power Query M Function). We will cover both methods today. Getting The Excel Date Set Ready To work through both of these examples we need to get the data set that we want to work with into Excel. We need to specifically get … [Read more...]