Tag: Calendar Layout

Calendar Layouts To Tabular Format Using Power Query

Tabular-Format-Using-Power-Query

In this tutorial, you’ll learn about turning multiple calendar type layouts into a tabular format using Power Query in Power BI. You’ll learn how to transform multiple files instead of a single file from a folder. You may watch the full video of this tutorial at the bottom of this blog. This tutorial will also

Continue reading

Creating A Calendar Table For Holidays In Power BI

This tutorial will address a common time intelligence issue about creating a Power BI calendar table with only holidays. You may watch the full video of this tutorial at the bottom of this blog. For time intelligence, the creation of a holiday table is a weird topic to start but it is one of the

Continue reading

Turning Calendar Type Layout Into Tabular Format In Power BI Using Query Editor

Turn Calendar Type Layout Into Tabular Format In Power BI Query Editor Tutorial

Analyzing the data that we have can be difficult if it is not correctly arranged. In this tutorial, I will explain how to transform vertical and horizontal repeated data into a tabular format. We do this so that we can have an easier time analyzing it using Power BI. You may watch the full video

Continue reading