Ask MCT Chris

Intro

Insert Data in a SQL Server Database table from a CSV File using the BULK INSERT Command

Read API Data in Power BI using Power Query

Parse JSON file using OPENROWSET and OPENJSON in Transact-SQL

DAX - Count No of Working Days

Get Data using Python Script in Power BI

Optimized your Power BI Report

LAMBDA Function in Excel

How to make a Progress Chart using the Donut Chart of Power BI

Using RANKX and EARLIER Functions in Power BI

How to install Greenbone OpenVAS on a Parrot OS machine

How to do a Distinct Count in Excel using the UNIQUE function and COUNTA function

Data Entry Form for your Excel Workbook using Microsoft Form

ChatGPT in Excel Using Office Scripts

Power BI Matrix - Show values in Row Groups rather than in Columns

Many-to-Many Relationship in Power BI

Using ChatGPT in PowerApps

How to add Holidays in the DATE Table in Power BI

How to create a SharePoint list from an Excel file

ChatGPT in PowerBI Desktop

Field Parameters in Power BI

Interactive Dashboard Using Power Pivot in Excel

How to create an Outlook Calendar reminder and update a SharePoint List using Power Automate

Calling Stored Procedure with Parameters in Power BI

Many-to-One Relationship DAX CROSSFILTER

Intro