diff options
Diffstat (limited to 'node_modules/shiki/samples/dax.sample')
-rw-r--r-- | node_modules/shiki/samples/dax.sample | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/node_modules/shiki/samples/dax.sample b/node_modules/shiki/samples/dax.sample new file mode 100644 index 0000000..e095c74 --- /dev/null +++ b/node_modules/shiki/samples/dax.sample @@ -0,0 +1,19 @@ +-- 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/ |