Tag: Date Table

Filtering Data By Custom Fiscal Years And Quarters Using Calculated Columns In Power BI

There can be times when your date tables won’t have the custom fiscal years and quarters that you require as filters for your analysis. In this tutorial, we are going to discuss how you can filter your data by financial or fiscal years and quarters using calculated columns in Power BI. I’ve already seen inquiries

Continue reading

How To Create Unique Financial Year Quarters Using A Calculated Column

If you had the opportunity to view the detailed date table tutorial that I ran through in a previous post, you will find that most of the supporting date columns like months, quarters, and financial years are generally made up for a standard calendar date table. In a lot of cases though, you need to

Continue reading

Build A Comprehensive Date Table In Power BI Really Fast

Enterprise DNA Power BI Video Tutorial Create a Detailed Date Table Fast

In this post, I’m going to show you what is probably the quickest and most effective way to create a detailed date table in Power BI. If you want to analyze anything over time, there is likely no more important table to create for any Power BI model than a great date table. Creating The

Continue reading