Created
March 11, 2021 12:55
-
-
Save GabrielMMelo/fa52cc8549e8b6557d7fae08c2d7f07c to your computer and use it in GitHub Desktop.
DAX language support for notepad++ (based on http://sascha-kasper.com/dax-syntax-highlighting-for-notepad/)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <NotepadPlus> | |
| <UserLang name="DAX2" ext="dax" udlVersion="2.1"> | |
| <Settings> | |
| <Global caseIgnored="no" allowFoldOfComments="yes" foldCompact="no" forcePureLC="0" decimalSeparator="0" /> | |
| <Prefix Keywords1="no" Keywords2="no" Keywords3="no" Keywords4="no" Keywords5="no" Keywords6="no" Keywords7="no" Keywords8="no" /> | |
| </Settings> | |
| <KeywordLists> | |
| <Keywords name="Comments">00-- 01 02 03% 04%</Keywords> | |
| <Keywords name="Numbers, prefix1"></Keywords> | |
| <Keywords name="Numbers, prefix2"></Keywords> | |
| <Keywords name="Numbers, extras1"></Keywords> | |
| <Keywords name="Numbers, extras2"></Keywords> | |
| <Keywords name="Numbers, suffix1"></Keywords> | |
| <Keywords name="Numbers, suffix2"></Keywords> | |
| <Keywords name="Numbers, range"></Keywords> | |
| <Keywords name="Operators1">+ - * / ^ = > < >= <= <> & && || !</Keywords> | |
| <Keywords name="Operators2"></Keywords> | |
| <Keywords name="Folders in code1, open">(</Keywords> | |
| <Keywords name="Folders in code1, middle"></Keywords> | |
| <Keywords name="Folders in code1, close">)</Keywords> | |
| <Keywords name="Folders in code2, open"></Keywords> | |
| <Keywords name="Folders in code2, middle"></Keywords> | |
| <Keywords name="Folders in code2, close"></Keywords> | |
| <Keywords name="Folders in comment, open"></Keywords> | |
| <Keywords name="Folders in comment, middle"></Keywords> | |
| <Keywords name="Folders in comment, close"></Keywords> | |
| <Keywords name="Keywords1">CALENDAR
CALENDARAUTO
DATE
DATEDIFF
DATEVALUE
DAY
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
YEAR
YEARFRAC
CLOSINGBALANCEMONTH
CLOSINGBALANCEQUARTER
CLOSINGBALANCEYEAR
DATEADD
DATESBETWEEN
DATESINPERIOD
DATESMTD
DATESQTD
DATESYTD
ENDOFMONTH
ENDOFQUARTER
ENDOFYEAR
FIRSTDATE
FIRSTNONBLANK
LASTDATE
LASTNONBLANK
NEXTDAY
NEXTMONTH
NEXTQUARTER
NEXTYEAR
OPENINGBALANCEMONTH
OPENINGBALANCEQUARTER
OPENINGBALANCEYEAR
PARALLELPERIOD
PREVIOUSDAY
PREVIOUSMONTH
PREVIOUSQUARTER
PREVIOUSYEAR
SAMEPERIODLASTYEAR
STARTOFMONTH
STARTOFQUARTER
STARTOFYEAR
TOTALMTD
TOTALQTD
TOTALYTD
DISTINCTCOUNTNOBLANK
CONTAINSSTRINGEXACT
CONTAINSSTRING
USERCULTURE
ALLCROSSFILTERED
APPROXIMATEDISTINCTCOUNT</Keywords> | |
| <Keywords name="Keywords2">ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATANH
CEILING
COMBIN
COMBINA
COS
COSH
CURRENCY
DEGREES
DIVIDE
EVEN
EXP
FACT
FLOOR
GCD
INT
ISO.CEILING
LCM
LN
LOG
LOG10
INT
MROUND
ODD
PI
POWER
PRODUCT
PRODUCTX
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROUND
ROUNDDOWN
ROUNDUP
SIGN
SQRT
SUM
SUMX
TRUNC
DATATABLE
ERROR
EXCEPT
GENERATESERIES
GROUPBY
INTERSECT
ISEMPTY
NATURALINNERJOIN
NATURALLEFTOUTERJOIN
SUMMARIZECOLUMNS
Table Constructor
TREATAS
UNION
VAR</Keywords> | |
| <Keywords name="Keywords3">ADDMISSINGITEMS
ALL
ALLEXCEPT
ALLNOBLANKROW
ALLSELECTED
CALCULATE
CALCULATETABLE
CROSSFILTER Function
DISTINCT
EARLIER
EARLIEST
FILTER
FILTERS
HASONEFILTER
HASONEVALUE
ISCROSSFILTERED
ISFILTERED
KEEPFILTERS
RELATED
RELATEDTABLE
SELECTEDVALUE
SUBSTITUTEWITHINDEX
USERELATIONSHIP
VALUES</Keywords> | |
| <Keywords name="Keywords4">PATH
PATHCONTAINS
PATHITEM
PATHITEMREVERSE
PATHLENGTH</Keywords> | |
| <Keywords name="Keywords5">CONTAINS
CUSTOMDATA
ISBLANK
ISERROR
ISEVEN
ISLOGICAL
ISNONTEXT
ISNUMBER
ISONORAFTER
ISTEXT
LOOKUPVALUE
USERNAME
RETURN
UTCTODAY
UTCNOW
COMBINEVALUES
DISTINCT
T.INV.2T
T.DIST.RT
T.DIST.2T
T.DIST
NORM.S.INV
NORM.S.DIST
NORM.INV
NORM.DIST
ISINSCOPE
SELECTEDMEASUREFORMATSTRING
REMOVEFILTERS
CONVERT</Keywords> | |
| <Keywords name="Keywords6">ADDCOLUMNS
AVERAGE
AVERAGEA
AVERAGEX
BETA.DIST
BETA.INV
CHISQ.INV
CHISQ.INV.RT
CONFIDENCE.NORM
CONFIDENCE.T
COUNT
COUNTA
COUNTAX
COUNTBLANK
COUNTROWS
COUNTX
CROSSJOIN
DATATABLE
DISTINCTCOUNT
EXPON.DIST
GENERATE
GENERATEALL
GEOMEAN
GEOMEANX
MAX
MAXA
MAXX
MEDIAN
MEDIANX
MIN
MINA
MINX
PERCENTILE.EXC
PERCENTILE.INC
PERCENTILEX.EXC
PERCENTILEX.INC
POISSON.DIST
RANK.EQ
RANKX
ROW
SAMPLE
SELECTCOLUMNS
SIN
SINH
STDEV.P
STDEV.S
STDEVX.P
STDEVX.S
SQRTPI
SUMMARIZE
TAN
TANH
TOPN
VAR.P
VAR.S
VARX.P
VARX.S
XIRR
XNPV</Keywords> | |
| <Keywords name="Keywords7">AND
FALSE
IF
IFERROR
NOT
OR
SWITCH
TRUE</Keywords> | |
| <Keywords name="Keywords8">BLANK
CODE
CONCATENATE
CONCATENATEX
EXACT
FIND
FIXED
FORMAT
LEFT
LEN
LOWER
MID
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
TRIM
UNICHAR
UPPER
VALUE</Keywords> | |
| <Keywords name="Delimiters">00[ 01 02] 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23</Keywords> | |
| </KeywordLists> | |
| <Styles> | |
| <WordsStyle name="DEFAULT" fgColor="F8F8F2" bgColor="282A36" fontName="琀愀琀甀猀 䴀攀攀琀椀渀最猀" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="COMMENTS" fgColor="008000" bgColor="282A36" fontName="" fontStyle="2" nesting="0" /> | |
| <WordsStyle name="LINE COMMENTS" fgColor="008000" bgColor="282A36" fontName=" 䜀攀渀攀爀愀氀" fontStyle="2" nesting="0" /> | |
| <WordsStyle name="NUMBERS" fgColor="F8F8F2" bgColor="282A36" fontName="㬬幡俞뢺誛鮬�" fontStyle="3" nesting="0" /> | |
| <WordsStyle name="KEYWORDS1" fgColor="0080C0" bgColor="282A36" fontName="倀ऀЀ劾챒剳챒⹴" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="KEYWORDS2" fgColor="0080C0" bgColor="282A36" fontName="rosoft JhengHei" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="KEYWORDS3" fgColor="0080C0" bgColor="282A36" fontName="D	뻯" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="KEYWORDS4" fgColor="0080C0" bgColor="282A36" fontName="敲䐀ऀЀ¾" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="KEYWORDS5" fgColor="0080C0" bgColor="282A36" fontName="" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="KEYWORDS6" fgColor="0080C0" bgColor="282A36" fontName="" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="KEYWORDS7" fgColor="0080C0" bgColor="282A36" fontName="" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="KEYWORDS8" fgColor="0080FF" bgColor="282A36" fontName="" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="OPERATORS" fgColor="8080FF" bgColor="282A36" fontName="변舊Ʒ" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="FOLDER IN CODE1" fgColor="FF8000" bgColor="282A36" fontName="" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="FOLDER IN CODE2" fgColor="F8F8F2" bgColor="282A36" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="FOLDER IN COMMENT" fgColor="008000" bgColor="282A36" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="DELIMITERS1" fgColor="8080FF" bgColor="282A36" fontName="" fontStyle="1" nesting="0" /> | |
| <WordsStyle name="DELIMITERS2" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="DELIMITERS3" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="DELIMITERS4" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="DELIMITERS5" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="DELIMITERS6" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="DELIMITERS7" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" nesting="0" /> | |
| <WordsStyle name="DELIMITERS8" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" nesting="0" /> | |
| </Styles> | |
| </UserLang> | |
| </NotepadPlus> |
This looks nice. Thanks for sharing (the later link seems broken btw).
I'm not using DAX anymore, though.
does this zip file contain autocomplete file as well ?
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
There is a nice and mature work from skasper user in powerbi community forum from MS, now on version 4.00, including autocompletion. Take a look.
Sascha-kasper site
comunity forum