DAX ACCRINT Function
The DAX ACCRINT function calculates the accrued interest for a security that pays periodic interest….
DAX ACCRINT Function
The DAX ACCRINT function calculates the accrued interest for a security that pays periodic interest. It takes several arguments, including the issue date, first interest date, settlement date, annual coupon rate, par value, frequency of payments, day count basis, and a logical value to determine the calculation method. The function returns the total accrued interest…
DAX ABS Function
ABS stands for Absolute Value. It takes a number as input and returns its distance from zero, basically ignoring the positive or negative sign. So, ABS(5) returns 5, and ABS(-3) returns 3. You can use ABS to convert negative numbers into positives for calculations that only work with non-negative values. Imagine you need to find…
Python Lesson 001: Introduction, Installation and Options
This video provides a comprehensive introduction to Python, covering various aspects from installation to online usage and integration with Excel and Power BI. It highlights the versatility of Python, its applications in diverse fields, and the multiple ways to access and utilize it. The video also demonstrates basic Python code examples, such as variable assignment,…
Python Lesson 002: Communicating with Python using Print() and Input() Functions
Python offers a straightforward way to interact with the user through the print() and input() functions. The print() function displays information on the console, taking one or more arguments like strings, numbers, or variables. It can also be used to format output, write to files, and display results in real time. The input() function prompts…
Python: Complete Free Course
This is a series of on going video tutorials. Starting from the basics, in each video we will cover python topics one by one. If you intend to learn Python as a bigginer from start, we suggest you start this course. Python Lesson 001: Introduction, Installation and OptionsPython Lesson 002: Communicating with Python using Print()…
Creating Custom Functions in Excel without using VBA: A Deep Dive into LAMBDA
Traditionally, custom functions in Excel were created using VBA, a programming language. However, Microsoft introduced the LAMBDA function in 2020, allowing users to create custom functions without coding. Inspired by lambda calculus, LAMBDA functions are defined with a name, parameters, and a formula. They can be used directly or named for future reference. By using…
Creating Dynamic KPIs in Power BI Report Server using SQL Server Database
Welcome to another Power BI Report Server tutorial! In this video, we’ll guide you through the process of creating a Key Performance Indicator (KPI) using a SQL Server database. For this exercise, we’ve uploaded the Adventure Works database to our server. If you’re already familiar with Power BI Report Server, you can easily access it…
Calculating, Comparing, and Visualizing Simple Returns and Log Returns
Hey there, welcome to my MS Excel tutorial! In today’s video, we’re diving into the world of investment simulations using Microsoft Excel. I’ll walk you through the process of comparing simple returns with log returns, helping you gain a better understanding of these concepts. First off, log returns might sound a bit complex, but they’re…
Exploratory Data Analysis (EDA) on Netflix Userbase Dataset using Power BI and DAX
In this tutorial, we will perform Exploratory Data Analysis (EDA) on the Netflix userbase dataset. EDA is a technique used to summarize and analyze data sets using visualizations. The dataset contains various fields, including user ID, subscription type, monthly revenue, joining date, last payment date, country, age, gender, device, and plan duration. To get started,…
Create an Interactive Dashboard with Power BI – Explore World Airports
Welcome to our comprehensive Power BI Desktop tutorial where we will guide you through creating an engaging dashboard that showcases airports around the world. Join us as we dive into the powerful features of Power BI, utilizing maps, pie charts, column charts, and scatter charts to visualize airport data like never before. Step 1: Accessing…
