Interactive Examples

Stop reading examples. Try them.

Most Power BI references show you a formula and a result and leave it at that. On the function pages below, you can edit the numbers yourself and watch the actual result recalculate — right on the page, no Excel, no upload, unlimited use.

DAX

DIVIDE()

Set the denominator to 0 and watch the fallback trigger instead of an error.

IF()

Clear the false result and see the optional third argument actually return BLANK().

SWITCH(TRUE(), ...)

Reorder a condition and reproduce the exact shadowing bug the page warns about, yourself.

Power Query M

Text.Middle()

Shift Start by one and watch the zero-indexing off-by-one happen on a live character ruler.

Text.Split()

Type two separators back to back and get a real empty-string element, not a skipped one.

Date.AddMonths()

Add a month to January 31st and watch it clamp to February 28th instead of erroring.

Text.Contains()

Flip a case-sensitive false into true with the Comparer.OrdinalIgnoreCase checkbox.

Text.Trim()

Swap in a non-breaking space and see it survive trimming, made visible on a character ruler.

try ... otherwise

Type anything that isn't a date and watch the fallback catch it instead of erroring.

More on the way — see the changelog for what's new, or browse the full documentation.