Tag: Dates in Power BI

Dynamic Date Slicer In Power BI Using A Period Table


In today’s blog post, I’d like to discuss what we like to call the period table. The period table creates a distinct date range so you can slice your data any way you want. I’ll show you how you can create a dynamic date slicer in Power BI by using this period table. You may

Continue reading

Change Date Formats Using The Power Query Editor

power bi convert text to date post image

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. You may watch the full video of this tutorial at the bottom of this blog. This is from a recent Enterprise DNA member-only event which featured the production data of

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. You may watch the full video

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 may watch the full video of this tutorial at the bottom of this

Continue reading