Tag: Date Table Power BI

Power BI Template Creation: Guide & Tips

Power BI Template Creation Guide & Tips - Enterprise DNA

Today, you will learn how to create your perfect Power BI template file that is configured to your preferences and settings. This will save you 20 to 30 minutes every time you start up a Power BI report and will make Power BI work exactly the way you want it to. You can watch the full

Continue reading

Removing A Hidden Date Table In Power BI To Improve Performance

Removing A Hidden Date Table In Power BI To Improve Performance - Enterprise DNA

In this tutorial, you’ll learn how to remove a hidden date table in Power BI to reduce RAM usage and improve performance. Power BI automatically creates hidden date tables when you have the Auto date/time option enabled. To enable the Auto date/time, go to Options and then to the Data Load tab. Under the Time

Continue reading

Extended Date Table Power Query M Function

Extended Date Table Power Query M Function

In today’s blog post, we’ll take another look at the Power Query M function for the extended date table. Since initially posting the code, there have been a number of updates with the help of our Enterprise DNA community. It has grown into quite an extensive date table that pretty much covers everything you’ll likely

Continue reading

How To Use Power BI VALUES Function (DAX) –  Enterprise DNA

VALUES-Function-DAX-In-Power-BI, values function (dax) in power bi post image

In this tutorial, I’ll discuss how the VALUES Function (DAX) allows you to create useful automation when working on a model with multiple date measures. You can watch the full video of this tutorial at the bottom of this blog. The VALUES function (DAX) returns a one-column table that contains the distinct values from the

Continue reading

Power BI Financial Year To Date Calculations

Power BI Financial Year To Date Calculations

In this tutorial, I’m going to talk about Power BI financial year to date calculations. Achieving a year to date analysis of a selected period is quite complex, but I’ll demonstrate to you a formula technique that enables you to quickly create a cumulative total over your specific financial year. You can watch the full

Continue reading