PBI-DataVizzle

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "transform": [
    {"filter": "indexof(selectedDepartments, datum['Department']) >=0"},
    {"fold": ["Budgeted $", "Paid $"]},
    {
      "joinaggregate": [
        {"op": "min", "field": "value", "as": "min"},
        {"op": "max", "field": "value", "as": "max"}
      ],

PBI-DataVizzle

let
    P1 = "myParameter1",
    P2 = "myParameter2",
    #"Header" = Binary.ToText(Text.ToBinary(#"UserName"&":" & #"Password")),
    #"BaseURL" = "https://yourwebpage.com/api/3",
#"DaysLogic" = 
        if
            #"JIRA Days" = null
        then
            ""

PBI-DataVizzle

// This gist containt useful pieces of M Query code

PBI-DataVizzle

//This gist contains useful tabular editor scripts. 

PBI-DataVizzle

// This gist containt useful pieces of DAX code

PBI-DataVizzle

// =====================================
// Author: Darren Gosbell
// Date: 12 Apr 2023
// This script works in Tabular Editor and sets the MaxParallelismPerQuery 
// setting at the database level.
// =====================================

if (Model.Database.CompatibilityLevel < 1569)
{
    Model.Database.CompatibilityLevel = 1569;

PBI-DataVizzle

#r "System.Net.Http"
using System.Net.Http;
using System.Text;
using Newtonsoft.Json.Linq;

// You need to signin to https://platform.openai.com/ and create an API key for your profile then paste that key 
// into the apiKey constant below
const string apiKey = "<YOUR API KEY HERE>";
const string uri = "https://api.openai.com/v1/completions";
const string question = "Explain the following calculation in a few sentences in simple business terms without using DAX function names:\n\n";

PBI-DataVizzle

# Install the MicrosoftPowerBIMgmt module required for managing Power BI resources.
# This module is installed for the current user only, to avoid system-wide changes.
Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser

# Authenticate to the Power BI Service.
# This step is necessary to access and manage Power BI resources.
Login-PowerBIServiceAccount

# Function to retrieve all Power BI workspaces.
# It fetches data from the Power BI API and handles pagination to get all workspaces.

PBI-DataVizzle

Sparkline Line = 

// Static line color - use %23 instead of # for Firefox compatibility
VAR LineColor = "%2301B8AA"

// "Date" field used in this example along the X axis
VAR XMinDate = MIN('Table'[Date])
VAR XMaxDate = MAX('Table'[Date])

// Obtain overall min and overall max measure values when evaluated for each date

PBI-DataVizzle

let
  pqmath.Benford =
    let
      Benford = Function.From(
        type function (num as number) as record,
        (params) =>
          let
            len = Text.Length(Text.From(params{0})),
            first = if len >= 1 then Number.From(Text.ToList(Text.From(params{0})){0}) else null,
            second = if len >= 2 then Number.From(Text.ToList(Text.From(params{0})){1}) else null,