A DAX measure definition that formats the Revenue numbers in a wordly way. It spells out numbers 1,812,343,434,567,812 like to `one quadrillion eight hundred and twelve trillion three hundred and forty-three billion four hundred and thirty-five million five hundred and sixty-eight thousand eight hundred and twelve`

100%

A DAX measure definition that formats the Revenue numbers in a wordly way. It spells out numbers 1,812,343,434,567,812 like to `one quadrillion eight hundred and twelve trillion three hundred and forty-three billion four hundred and thirty-five million five hundred and sixty-eight thousand eight hundred and twelve`

✓ Published0🌍 Public

Last edited Mar 3, 2023

Created on Mar 3, 2023

This example demonstrates a DAX measure that converts a numeric Revenue value into its fully spelled-out English text, such as rendering 1,812,343,434,567,812 as “one quadrillion eight hundred and twelve trillion…” The measure uses the `CONCATENATEX` iterator with `GENERATESERIES` to break the number into groups of three digits, then applies nested `SWITCH` and `LOOKUPVALUE` functions against three lookup tables—`DigitWords`, `NumberWords`, and `Magnitude`—to map each group to its word form. The code also relies on `ADDCOLUMNS` for intermediate calculations and `ROUND` and `MOD` for digit extraction. The visualization shows the formatted result directly as text, with the lookup tables defined via the `DATATABLE` function.

AI-generated description

Similar vizzes

Loading thumbnail…

DAX measure that formats a measure `[Quantity]` into a roman numeral

This example shows a Power BI table where the `[Quantity]` measure is transformed into a roman numeral representation, displayed alongside the original numeric values for brands like A. Datum and Adventure Works. The DAX measure uses `GENERATESERIES` and `FLOOR` to extract each digit’s position, then `LOOKUPVALUE` against a static `DATATABLE` that maps powers of ten (1, 10, 100, up to 300,000) to their corresponding roman numerals, including overline notation for values above 3,999. The `CONCATENATEX` function concatenates these digit-specific roman strings in descending order of place value, producing outputs like `V̅I̅DCCCXCVII` for 6,897. The approach relies entirely on DAX’s table functions and does not use any external JavaScript libraries or rendering APIs.

HHugoberry

79% match

Loading thumbnail…

excel_function_BW2

This example displays a single computed revenue projection as a text value in the browser, annotated with “$ USD”. It calculates the number by running a complex statistical predictor function with fifteen hard-coded input parameters, combining logistic regression for sellout probability with separate regression models for expected gross and standard deviation, then scaling those against weekly averages. The visualization uses D3.js version 3.5.5 to append the result to the page, while all calculations rely on raw JavaScript math functions. No external data source is loaded; the input values and weekly benchmark figures are defined as variables in the code.

BBenHeubl

56% match

Loading thumbnail…

Exploring displaying microcharts and sparklines in table/matrix visual in PowerBI

This example demonstrates how to embed a wide range of microcharts and sparklines directly into Power BI table and matrix visuals using a single DAX measure. The measure returns a text string composed of Unicode block characters, which the visual renders as the final chart. The code includes a calculation table with pattern definitions for bar charts, bullet charts, win/loss charts, dot plots, candlestick charts, and horizontal comparison bars, each using characters like blocks, circles, and lines. The approach requires no external libraries, relying solely on DAX string manipulation and the native Unicode font rendering in the Power BI visual.

HHugoberry

56% match

Loading thumbnail…

Gist ba3a80c35942582d77235e9fb4173416

This example shows a small, inline sparkline generated as a Scalable Vector Graphic (SVG) image URL from a Power BI measure. It plots a measure’s values over time for a single category, mapping each date to an X coordinate and each value to a Y coordinate within a 100×100 viewBox. The code uses DAX variables like `MINX`, `MAXX`, and `SUMMARIZE` to compute the normalized coordinates, then concatenates them into a `polyline` string. The result is rendered as a data URI with `data:image/svg+xml;utf8`, relying on the table’s `Date` and `Category` fields.

HHugoberry

52% match

Loading thumbnail…

Power Query regex example from http://www.thebiccountant.com/2018/04/25/regex-in-power-bi-and-power-query-in-excel-with-java-script/

This example demonstrates how to extract numeric patterns from a mixed-language string using regular expressions within Power Query. It defines a custom function that invokes JavaScript’s `RegExp` and `String.match` via the `Web.Page` HTML/JavaScript execution environment, passing a target string and a regex pattern. The specific call extracts all digit sequences from “hello012中国1235” and returns them as a list. This approach highlights Power Query’s ability to leverage external scripting for text processing, bridging M’s native functions with JavaScript’s regex engine for advanced pattern matching.

HHugoberry

52% match

Loading thumbnail…

Drawing Homer Simpson in Power BI. DAX code for Y coordinates.

This example shows how to draw Homer Simpson’s head in Power BI by computing Y coordinates from a parametric equation, with a DAX measure named `HomerY` that takes an index and a function number as inputs. The measure uses ten distinct Fourier-series-like trigonometric functions (`fn0` through `fn9`), each selected via a `SWITCH` statement based on the function number, and evaluates the chosen expression using `LASTNONBLANK`. The code relies on DAX’s built-in math functions (e.g., `SIN`) and iterator `LASTNONBLANK` to access row context. The data comes from a table named `Homer`, and the visualization renders points whose Y values follow this formula, producing the iconic silhouette.

HHugoberry

51% match

Loading thumbnail…

Gist e75fdfd9429caf37873275cd41779b88

This example demonstrates a custom formatting function that inserts non-breaking spaces as thousands separators, a convention common in Finnish numeric formatting. The function, `spaceSeparateNumber`, iteratively processes the input number using a regular expression to identify digit groups, replacing them with a space between the leading digits and the trailing three-digit group. It relies on JavaScript’s string replacement and number-to-string conversion, without any external libraries. The visualization likely applies this formatting to numeric labels in a chart, ensuring readable, localized display of large values. The code focuses solely on text transformation, not on rendering or data binding, making it a standalone utility for formatting axis ticks or tooltip values.

EEelsie

51% match

Loading thumbnail…

K-means clustering in DAX

This example demonstrates a K-means clustering implementation written in DAX, showing how to group items into clusters based on multiple numeric attributes. The code computes a transformed table using `SUMMARIZECOLUMNS` to aggregate attribute values per item, then passes that table to a custom `KMeansClustering` function. The function assigns each item a `ClusterId` while preserving the original item labels. The visualization highlights the resulting clusters, with the DAX code serving as the core analytical engine rather than relying on a JavaScript library. The source is a gist by Hugoberry, and the rendering approach is not visible here, so the focus remains on the clustering logic and the data transformation pipeline.

HHugoberry

50% match