In this tutorial, we’re going to go over a quick solution on how to change date formats using the power query editor in Power BI. This is from a recent Enterprise DNA member-only event which featured the production data of an oil and gas company from a certain area in the United States. Inconsistent Date
One question I got from the Enterprise DNA forum revolves around an addition to the date query table. This addition prevents you from having to manually filter data to the last date every time new data comes in. This can be helpful if you’re working on an ongoing report. I’ll add a link to the
As soon as you start developing a few Power BI models, you’ll very likely run into a problem where you have two dates in your fact table and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date, invoiced date, shipped
