Creating a comprehensive calendar table is crucial for time-based analysis in Power BI. Here are 15 essential DAX functions to enhance...

Filtering dates from past weeks is pretty useful when you want to compare the trend of a particular weekday or weekend. Here's an example...

Transforming raw data from the left to the one on the right where the data is split nicely into each column. Let's look at the raw data,...

Having leading zeros is crucial when a standard data length is necessary. Here is a sample Calendar table featuring columns for Date,...

Below is a screenshot of time in Second format and in Minutes format. I'm going to show you to convert them into mm:ss format. Second to...

Transforming table on the left to table on the right. Let's look at the blue table below first, it can be seen that the Date column (to...

When appending tables in Power Query, the M code used looks something like below: =Table.Combine({Table1, Table2, Table3}) The problem...

Here's an example of ever changing headers where the dates are the headers of the data, basically means the headers change every month or...

Here's an example of a Pivot Table, and I want to automatically filter the past 30 days whenever I update the raw data and refresh it. So...

Imagine your boss giving you a dataset like below table and wanting you to include it in the Power BI dashboard and at the same time...

Calendar table is pretty useful as it can link different data sources to produce a consolidated reports or dashboards. For example, in...

Before diving into the steps for date formatting, we need to understand what is locale. Locale is used to display and identify the data...

During my initial days of transitioning to the data analysis field, I used to think that the most crucial part was the ability to use all...

This project is to create a dashboard in Excel to analyse Netflix Userbase. In this blog post, I'll show you how I did it. This is the...