Tag: Date Table

Time Intelligence In DAX: How To Dynamically Select Starting Period

Power BI Dynamically Select Starting Period

In this blog post, we will deal with some troublesome issues in time intelligence, particularly those issues caused by week granularity and the troubles that can be caused by the irregular number of weeks in a year. We’ll use offsets to come up with accurate time intelligence in DAX. We have an interesting scenario for

Continue reading

Power BI With Python Scripting To Create Date Tables

Python and Power BI This tutorial will discuss about creating and running date tables in Power BI with Python scripts. You’ll learn how to create data frames and import them to Power BI using the Python Script Loader and Jupyter Notebook. You’ll also learn how to export them out into a CSV or Excel format.

Continue reading

Data Loading And Transformation Best Practices

Data Loading And Transformation Best Practices

I’d like to present the best practices I’ve adopted while preparing Power BI reports. Over the past few years, I’ve consumed many online resources on data loading and transformation which have been instrumental in my journey, but I quickly became overwhelmed by the content, so I ended up making my own notes. You can watch

Continue reading

Dynamic Date Slicer In Power BI Using A Period Table

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

Compare Data Points From Different Timeframes In One Visualization – Power BI

Compare Data Points From Different Timeframes In One Visualization - Power BI

In this blog I’ll show you how you can compare data from different timeframes within the same visualization. You can get amazing Power BI insights using this great technique with time-related DAX. You may watch the full video of this tutorial at the bottom of this blog. I discovered this approach from the Enterprise DNA

Continue reading