Tag: Date Table

Power BI With Python Scripting To Create Date Tables

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. Importing Packages In Power

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

Sorting Date Table Columns In Power BI

Sorting Date Table Columns In Power BI

In today’s blog, I’ll discuss a question that comes up all the time in the Enterprise DNA forum. How can you can sort the fields from an extended date table columns properly? You may watch the full video of this tutorial at the bottom of this blog. This refers to the extended date table from

Continue reading