Advanced BQL Functions

• DATEDIFF
• FIND
• FORMAT
• FUNCTION and FUNCTIONLOOKUP
• GETPROMPTFILTER and GETPROMPTVALUE
• LET
• LOOKUPROW
• LOOKUPVALUE
• Math Functions
• MEDIAN
• NOW and NOWDATE
• RSUM
• SPARSE
• STAT
• TRANSFORM
• TREND