Skip to content

Instantly share code, notes, and snippets.

View PBI-DataVizzle's full-sized avatar
💭
Shizzle my Vizzle 🤓

Imran Haq PBI-DataVizzle

💭
Shizzle my Vizzle 🤓
View GitHub Profile
@PBI-DataVizzle
PBI-DataVizzle / fnErlangC.pq
Created November 19, 2023 14:31 — forked from cbaragao/fnErlangC.pq
Erlang C calculation in Power Query
let
fnErlangC =
(
number_of_calls as number,
period_of_minutes as number,
average_handling_time as number,
required_service_level as number,
target_answer_time as number,
maximum_occupancy as number,
/*
Function: fnHoltWinters
Description: Trying to replicate HoltWinters quantitative smoothing with Power Query.
Author: Chris Aragao
Change Log:
11.13.2023 - Initial release. Initial code was based off of this tutorial: https://www.exceldemy.com/holt-winters-exponential-smoothing-in-excel/.
It was aimed at solely duplicating the output and did so.
Sparkline =
// dummy value in a table
VAR _vals = {
( 0, 500 ),
( 1, 700 ),
( 2, 1200 ),
( 3, 1250 ),
( 4, 550 ),
( 5, 780 ),
( 6, 990 ),
target card =
// unsat, below, near, hit
VAR _Q1_result = "unsat"
VAR _Q2_result = "below"
VAR _Q3_result = "near"
VAR _Q4_result = "hit"
@PBI-DataVizzle
PBI-DataVizzle / vl_UN_URL
Created November 11, 2023 20:57
url to vega-online editor
https://vega.github.io/editor/#/url/vega-lite/N4KABGBEAWCmCWBzaAXSAuMBWADDgNOFAO7wAmK0G2ehEkZAhio9aBBOJAG6MA2AV1gBnagG0iEdhxmQAmrEYAnagEYAnLjoyOkAKoA5agDsBfPtp1QAkgAkAsgFETZi5J2Rr1gIIBlby7mlh6GAPq28MIoAPZK8ADG-NQATAAsAOzpAGzpuLTushHIsCqYpkEFugAy0cQlgW5W9AAizLDUkDiqAPRd3Rq4kO4AvsHSVvKKpWADqsGyhg3zunZOS5X0Xn4BZa7L9GERUbEJSZjJWMk46ul4+U1QRXDT5Y1NkDV1L3sbUK0o7UwnR6fVmQxko3c4w8CmUak0yX2UEWuwqD08DmcqLeEy2-nW6MOkRicUSfBSWCyl3UqjuSMgT3q2PpnyZYFe9P+gKgfVBCPBHEhMmhslh0wGAGZ6Sj2T90assbK0e88TslTiQgZwsSTmSUllVJcsLT7u9Gd9lRNWRaNbIuR1eT1JQKIEKOCLdGL4VhUtKjMzfhi1gH5T58SH3kTjqSzmBklkqRKcLdTRNzQT3taMxN7UDHf1NKkXWA3VJA17MAMsH7sx4FbXZKqG7ooyTTuTzulVAAOKlXVMedMRq21NkcwO5nkgp2aLDF0tgD30CszTRZGvDuuY5ubMNq8eErVHNt6zvpCWpdRJgeFJDPHdQLObu1tB3TguU+djctTb3pDfqvS9bPise4PvoR46jGHZxt2yTdsa14EIGQ6AYGT5oeik7Ar0M5YOkX5Qj+cKVpo3YAQeKrbiBu7bOBra6rG8HdukyTJCayHoqhlEjl84HYfmAzdoRwrEeKmjqBRcpUcGmEqmBNHIpB0btik6ipJemh0ihd5jtJvF6ZaHgCe+AzqCJ7pifCWScZG-pybi1EOXWCnOQsyknkx6izt26jaVxuk2iyo5BROr55qZ6g2RZZboiuGgGlJRmNk5PEuXRikQdqKmnmASapPB6Tdv5ZqBeBGFpS+
@PBI-DataVizzle
PBI-DataVizzle / UN_Population.json
Created November 11, 2023 20:56
UN Population Chart for Vega-Lite Online Editor
{
"data": {
"values": [
{
"Year": 1950,
"UN": null,
"IHME": null,
"IIASA": null,
"UN_Historical": 2477675000,
"Higher": null,
{
"$schema": "https://vega.github.io/schema/vega-lite/v5.json",
"usermeta": {
"deneb": {
"build": "1.5.1.0",
"metaVersion": 1,
"provider": "vegaLite",
"providerVersion": "5.6.1"
},
"interactivity": {
{
"title": {
"text": "% Rating based on Category Type",
"anchor": "middle",
"color": "white",
"font": "helvatica",
"fontSize": 30
},
"data": {
"values": [
@PBI-DataVizzle
PBI-DataVizzle / pbi_theme_headericons.json
Last active August 25, 2023 14:10
pbi_theme_Global_HeaderIcons
{
"name": "My New Theme",
"visualStyles": {
"*": {
"*": {
"visualHeader": [{
"show": false,
"showOptionsMenu": false,
"transparency": 0,
"foreground": {