Tag: Dates in Power BI

Change Date Formats Using The Power Query Editor

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

Continue reading

Creating a Dynamic Date Query Table in Power BI: A Query Editor Tutorial

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

Continue reading

How To Work With Multiple Dates In Power BI

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

Continue reading