nyx/vim
1
0
Fork 0
mirror of https://github.com/vim/vim synced 2025-04-30 05:17:45 +02:00
Code Issues 1 Projects Releases Packages Wiki Activity Actions 3
vim/runtime/syntax/dax.vim
Anarion Dunedain 7f518e044f
patch 9.1.1268: filetype: dax files are not recognized 
Problem:  filetype: dax files are not recognized
Solution: detect "*.dax" as dax filetype, include dax filetype and
          syntax plugin (Anarion Dunedain)

Data Analysis Expressions (DAX) is a formula expression language used in
Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas
include functions, operators, and values to perform advanced
calculations and queries on data in related tables and columns in
tabular data models.

DAX language overview:
- https://learn.microsoft.com/en-us/dax/dax-overview

closes: #17035

Signed-off-by: Anarion Dunedain <anarion80@gmail.com>
Signed-off-by: Christian Brabandt <cb@256bit.org>
2025-04-02 19:54:31 +02:00

151 lines
7.3 KiB
VimL
Raw Permalink Blame History

" Vim syntax file
" Language: Data Analysis Expressions (DAX)
" Maintainer: Anarion Dunedain <anarion80@gmail.com>
" Last Change:
" 2025 Mar 28 First version
" quit when a syntax file was already loaded
if exists("b:current_syntax")
finish
endif
let s:keepcpo = &cpo
set cpo&vim
" There are DAX functions with dot in the name (like VARX.S)
setlocal iskeyword+=.
" DAX is case insensitive
syn case ignore
" DAX statements
syn keyword daxStatement DEFINE EVALUATE MEASURE RETURN VAR
syn match daxStatement "ORDER\ BY"
syn match daxStatement "START\ AT"
" TODO
syn keyword daxTodo FIXME NOTE TODO OPTIMIZE XXX HACK contained
" DAX functions
syn keyword daxFunction
\ ABS ACCRINT ACCRINTM ACOS ACOSH ACOT ACOTH
\ ADDCOLUMNS ADDMISSINGITEMS ALL ALLCROSSFILTERED ALLEXCEPT ALLNOBLANKROW ALLSELECTED
\ AMORDEGRC AMORLINC AND APPROXIMATEDISTINCTCOUNT ASIN ASINH ATAN
\ ATANH AVERAGE AVERAGEA AVERAGEX BETA.DIST BETA.INV BITAND
\ BITLSHIFT BITOR BITRSHIFT BITXOR BLANK CALCULATE CALCULATETABLE
\ CALENDAR CALENDARAUTO CEILING CHISQ.DIST CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT
\ CLOSINGBALANCEMONTH CLOSINGBALANCEQUARTER CLOSINGBALANCEYEAR COALESCE COLUMNSTATISTICS COMBIN COMBINA
\ COMBINEVALUES CONCATENATE CONCATENATEX CONFIDENCE.NORM CONFIDENCE.T CONTAINSROW
\ CONTAINSSTRING CONTAINSSTRINGEXACT CONVERT COS COSH COT COTH
\ COUNT COUNTA COUNTAX COUNTBLANK COUNTROWS COUNTX COUPDAYBS
\ COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CROSSFILTER CROSSJOIN
\ CUMIPMT CUMPRINC CURRENCY CURRENTGROUP CUSTOMDATA DATATABLE DATE
\ DATEADD DATEDIFF DATESBETWEEN DATESINPERIOD DATESMTD DATESQTD DATESYTD
\ DATEVALUE DAY DB DDB DEGREES DETAILROWS DISC
\ DISTINCT column DISTINCT table DISTINCTCOUNT DISTINCTCOUNTNOBLANK DIVIDE DOLLARDE DOLLARFR
\ DURATION EARLIER EARLIEST EDATE EFFECT ENDOFMONTH ENDOFQUARTER
\ ENDOFYEAR EOMONTH ERROR EVALUATEANDLOG EVEN EXACT EXCEPT
\ EXP EXPON.DIST FACT FALSE FILTER FILTERS FIND
\ FIRST FIRSTDATE FIXED FLOOR FORMAT FV GCD
\ GENERATE GENERATEALL GENERATESERIES GEOMEAN GEOMEANX GROUPBY HASONEFILTER
\ HASONEVALUE HOUR IF IF.EAGER IFERROR IGNORE INDEX
\ INFO.ALTERNATEOFDEFINITIONS INFO.ANNOTATIONS INFO.ATTRIBUTEHIERARCHIES INFO.ATTRIBUTEHIERARCHYSTORAGES INFO.CALCDEPENDENCY INFO.CALCULATIONGROUPS INFO.CALCULATIONITEMS
\ INFO.CATALOGS INFO.CHANGEDPROPERTIES INFO.COLUMNPARTITIONSTORAGES INFO.COLUMNPERMISSIONS INFO.COLUMNS INFO.COLUMNSTORAGES INFO.CSDLMETADATA
\ INFO.CULTURES INFO.DATACOVERAGEDEFINITIONS INFO.DATASOURCES INFO.DELTATABLEMETADATASTORAGES INFO.DEPENDENCIES INFO.DETAILROWSDEFINITIONS INFO.DICTIONARYSTORAGES
\ INFO.EXCLUDEDARTIFACTS INFO.EXPRESSIONS INFO.EXTENDEDPROPERTIES INFO.FORMATSTRINGDEFINITIONS INFO.FUNCTIONS INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES INFO.GROUPBYCOLUMNS
\ INFO.HIERARCHIES INFO.HIERARCHYSTORAGES INFO.KPIS INFO.LEVELS INFO.LINGUISTICMETADATA INFO.MEASURES INFO.MODEL
\ INFO.OBJECTTRANSLATIONS INFO.PARQUETFILESTORAGES INFO.PARTITIONS INFO.PARTITIONSTORAGES INFO.PERSPECTIVECOLUMNS INFO.PERSPECTIVEHIERARCHIES INFO.PERSPECTIVEMEASURES
\ INFO.PERSPECTIVES INFO.PERSPECTIVETABLES INFO.PROPERTIES INFO.QUERYGROUPS INFO.REFRESHPOLICIES INFO.RELATEDCOLUMNDETAILS INFO.RELATIONSHIPINDEXSTORAGES
\ INFO.RELATIONSHIPS INFO.RELATIONSHIPSTORAGES INFO.ROLEMEMBERSHIPS INFO.ROLES INFO.SEGMENTMAPSTORAGES INFO.SEGMENTSTORAGES INFO.STORAGEFILES
\ INFO.STORAGEFOLDERS INFO.STORAGETABLECOLUMNS INFO.STORAGETABLECOLUMNSEGMENTS INFO.STORAGETABLES INFO.TABLEPERMISSIONS INFO.TABLES INFO.TABLESTORAGES
\ INFO.VARIATIONS INFO.VIEW.COLUMNS INFO.VIEW.MEASURES INFO.VIEW.RELATIONSHIPS INFO.VIEW.TABLES INT INTERSECT
\ INTRATE IPMT ISAFTER ISBLANK ISCROSSFILTERED ISEMPTY ISERROR
\ ISEVEN ISFILTERED ISINSCOPE ISLOGICAL ISNONTEXT ISNUMBER ISO.CEILING
\ ISODD ISONORAFTER ISPMT ISSELECTEDMEASURE ISSUBTOTAL ISTEXT KEEPFILTERS
\ LAST LASTDATE LCM LEFT LEN LINEST LINESTX
\ LN LOG LOG10 LOOKUPVALUE LOWER MATCHBY MAX
\ MAXA MAXX MDURATION MEDIAN MEDIANX MID MIN
\ MINA MINUTE MINX MOD MONTH MOVINGAVERAGE MROUND
\ NATURALINNERJOIN NATURALLEFTOUTERJOIN NETWORKDAYS NEXT NEXTDAY NEXTMONTH NEXTQUARTER
\ NEXTYEAR NOMINAL NONVISUAL NORM.DIST NORM.INV NORM.S.DIST NORM.S.INV
\ NOT NOW NPER ODD ODDFPRICE ODDFYIELD ODDLPRICE
\ ODDLYIELD OFFSET OPENINGBALANCEMONTH OPENINGBALANCEQUARTER OPENINGBALANCEYEAR OR ORDERBY
\ PARALLELPERIOD PARTITIONBY PATH PATHCONTAINS PATHITEM PATHITEMREVERSE PATHLENGTH
\ PDURATION PERCENTILE.EXC PERCENTILE.INC PERCENTILEX.EXC PERCENTILEX.INC PERMUT PI
\ PMT POISSON.DIST POWER PPMT PREVIOUS PREVIOUSDAY PREVIOUSMONTH
\ PREVIOUSQUARTER PREVIOUSYEAR PRICE PRICEDISC PRICEMAT PRODUCT PRODUCTX
\ PV QUARTER QUOTIENT RADIANS RAND RANDBETWEEN RANGE
\ RANK RANK.EQ RANKX RATE RECEIVED RELATED RELATEDTABLE
\ REMOVEFILTERS REPLACE REPT RIGHT ROLLUP ROLLUPADDISSUBTOTAL ROLLUPGROUP
\ ROLLUPISSUBTOTAL ROUND ROUNDDOWN ROUNDUP ROW ROWNUMBER RRI
\ RUNNINGSUM SAMEPERIODLASTYEAR SAMPLE SEARCH SECOND SELECTCOLUMNS SELECTEDMEASURE
\ SELECTEDMEASUREFORMATSTRING SELECTEDMEASURENAME SELECTEDVALUE SIGN SIN SINH SLN
\ SQRT SQRTPI STARTOFMONTH STARTOFQUARTER STARTOFYEAR STDEV.P STDEV.S
\ STDEVX.P STDEVX.S SUBSTITUTE SUBSTITUTEWITHINDEX SUM SUMMARIZE SUMMARIZECOLUMNS
\ SUMX SWITCH SYD T.DIST T.DIST.2T T.DIST.RT T.INV
\ T.INV.2t TAN TANH TBILLEQ TBILLPRICE TBILLYIELD TIME
\ TIMEVALUE TOCSV TODAY TOJSON TOPN TOTALMTD TOTALQTD
\ TOTALYTD TREATAS TRIM TRUE TRUNC Table Constructor UNICHAR
\ UNICODE UNION UPPER USERCULTURE USERELATIONSHIP USERNAME USEROBJECTID
\ USERPRINCIPALNAME UTCNOW UTCTODAY VALUE VALUES VAR.P VAR.S
\ VARX.P VARX.S VDB WEEKDAY WEEKNUM WINDOW XIRR
\ XNPV YEAR YEARFRAC YIELD YIELDDISC YIELDMAT
" CONTAINS is a vim syntax keyword and can't be a defined keyword
syn match daxFunction "CONTAINS"
" Numbers
" integer number, or floating point number without a dot.
syn match daxNumber "\<\d\+\>"
" floating point number, with dot
syn match daxNumber "\<\d\+\.\d*\>"
syn match daxFloat "[-+]\=\<\d\+[eE][\-+]\=\d\+"
syn match daxFloat "[-+]\=\<\d\+\.\d*\([eE][\-+]\=\d\+\)\="
syn match daxFloat "[-+]\=\<\.\d\+\([eE][\-+]\=\d\+\)\="
" String and Character constants
syn region daxString start=+"+ end=+"+
" DAX Table and Column names
syn region daxTable start=+'+ms=s+1 end=+'+me=e-1
syn region daxColumn matchgroup=daxParen start=/\[/ end=/\]/
" Operators
syn match daxOperator "+"
syn match daxOperator "-"
syn match daxOperator "*"
syn match daxOperator "/"
syn match daxOperator "\^"
syn match daxOperator "\ NOT(\s\|\\)"
syn match daxOperator "\ IN\ "
syn match daxOperator "&&"
syn match daxOperator "&"
syn match daxOperator "\\|\\|"
syn match daxOperator "[<>]=\="
syn match daxOperator "<>"
syn match daxOperator "="
syn match daxOperator ">"
syn match daxOperator "<"
" Comments
syn region daxComment start="\(^\|\s\)\//" end="$" contains=daxTodo
syn region daxComment start="/\*" end="\*/" contains=daxTodo
" Define highlighting
hi def link daxComment Comment
hi def link daxNumber Number
hi def link daxFloat Float
hi def link daxString String
hi def link daxStatement Keyword
hi def link daxOperator Operator
hi def link daxFunction Function
hi def link daxTable Number
hi def link daxColumn Statement
hi def link daxParen Delimiter
hi def link daxTodo Todo
let b:current_syntax = "dax"
let &cpo = s:keepcpo
unlet! s:keepcpo
" vim: ts=8
Reference in a new issue View git blame Copy permalink