Excel embedded HTML code <iframe src="https://apps.powerapps.com/play/46fa0XXXXXbb43-e86da93bdc60?tenantId=XXXXX-4cd1-9ead-21a8XXXXX"...

Northwind dashboard created in Power BI Desktop.

What Is the Compound Annual Growth Rate (CAGR)? The compound annual growth rate (CAGR) is the rate of return (RoR) that would be required...

Excel blog about Cohort analysis: Customer Retention & Cohort Analysis (mavaanalytics.com) Sample Data First thing I need to do is to add...

Using T-SQL Stored Procedure to create a report in Power BI Report Builder. Data set: Using T-SQL to create a bank loan statement...

Power BI Model: I have two tables. Sales with transactions and dimension table for filtering. 1. If no filter is applied. Chart 1: shows...

Data Models Data are loaded from the data warehouse database. Using Import Mode. Can't use DirectQuery Mode for Live Connection because I...

Web source: Database index (planecrashinfo.com) Goal is to extract the accident details for each year and date. That means get a access...

Information functions Filter functions Table manipulation functions Grouping and summarizing Time intelligence functions...

Create a calendar in Power Query or using a DAX language. example 1 > M code. This calendar starts from 01. 01.2010 and the dates are...

Lag and Lead are functions used in many programming languages that provides access to a row at a specified physical offset which comes...

We want to calculate number of days between start date and end date. Then we want to exclude weekends. And at the end holidays. Source...

A rolling average also known as moving average is a statistical method that calculates the average of a data series for a given period....

I have a multiple excel files in one folder with the same metadata (structure). These tables are not proper tables, require some...

I have couple of files with different date and value formats. Will use a function which will format them correctly... Source files: There...

Power query, append tables using M code.

Link to dashboard: https://app.powerbi.com/view?r=eyJrIjoiNzFlNmM3YzEtYzE2ZC00Mjk1LWE1MDctNGM4MzgxZjhkYTUwIiwidCI6IjQyNTFlNjhmLTEzZjctNG...

A look at the new covid-19 cases through the 14 day period.