0

Power Query

May 8, 2024

2 Min Read

Power Query NetworkDays

This post is to show how to create Power Query NetworkDays function to calculate the variance between two days for working days only, with an option to exclude public holidays…

Uncategorized

April 22, 2024

1 Min Read

Pandas Melt example

Creating a sample dataset that could be used to unpivot data using Pandas Melt function. import pandas as pd Sample data: sales figures for different products over several months data…

DAX

April 22, 2024

1 Min Read

DAX Cumulative

Dax Cumulative formula typically involves creating calculations that accumulate values over time, such as running totals or cumulative sums.

0

Power BI

March 29, 2024

2 Min Read

Power BI March 2024 Update

Power BI March 2024 Update Summary Earn a free Microsoft Fabric certification exam!  We are thrilled to announce the general availability of Exam DP-600, which leads to the Microsoft Certified: Fabric Analytics…

0

Slice of Life

March 29, 2024

2 Min Read

Deadpool & Wolverine: A Marvelous B...

Marvel Studios is poised to redefine superhero team-ups with its latest cinematic endeavour, “Deadpool & Wolverine”, scheduled for release on July 26, 2024. This film, marking the 34th installment in…

0

Slice of Life

March 23, 2024

1 Min Read

Marvel movies in order. Chronological &#...

Marvel’s cinematic universe, known as the MCU, has released many movies over the years, here are two ways to watch Marvel movies in order. Last updated: 29/03/2024

0

Power Apps

February 24, 2024

9 Min Read

Creating a Dynamic Loading Bar Animation...

This post explores the technical details of creating a dynamic loading bar animation in Power Apps. It’s designed to visually indicate app progress, effectively reducing perceived wait times and keeping…

1

Power BI

February 18, 2024

4 Min Read

Global Inflation – Power BI Analys...

In the rapidly evolving global economy, understanding inflation trends is crucial for analysts, economists, and financial enthusiasts. Inflation affects purchasing power, interest rates, and economic policies. With the rich dataset…

0

Power BI

February 16, 2024

2 Min Read

Power BI Report Compliance Management

Creating a SharePoint list to manage Power BI report compliance is a great way to streamline report management and ensure all your Power BI reports meet your organization’s compliance requirements….

0

SQL

February 13, 2024

2 Min Read

SQL SELECT

The SQL SELECT statement is the cornerstone of database operations, designed to query data from tables within a database. It allows you to specify exactly which data you want to…