# code-block-pro/1.27.7/build/shiki/samples/dax.sample

Code Block Pro – Beautiful Syntax Highlighting, version 1.27.7. 20 lines.

- Page: https://pluginprobe.com/plugins/code-block-pro/1.27.7/code/build/shiki/samples/dax.sample
- Raw: https://pluginprobe.com/plugins/code-block-pro/1.27.7/raw/build/shiki/samples/dax.sample
- Modified: 2023-01-28T16:44:20+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/code-block-pro/1.27.7/code/build/shiki/samples/dax.sample#L10-L20`.

```
--  COALESCE returns the first non-blank of its arguments
--  It is commonly used to provide default values to expressions
--  that might result in a blank
EVALUATE
SELECTCOLUMNS (
    TOPN ( 10, Store ),
    "Store name", Store[Store Name],
    "Manager",
        COALESCE ( Store[Area Manager], "** Not Assigned **" ),
    "Years open",
        DATEDIFF (
            Store[Open Date],
            COALESCE ( Store[Close Date], TODAY () ),
            YEAR
        )
)
ORDER BY [Manager]

-- From https://dax.guide/coalesce/

```