Daily Shaarli
February 11, 2021
Can Tabular Editor read/import DAX Code from a file to update a model? · Issue #704 · otykier/TabularEditor · GitHub
Let's say I have a file, myfile.txt, with the following content:
$ git status
There is a concept in the DAX language called “Syntax Sugar”. Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use the DAX language. Here are a couple of examples
WITH seq(n) AS
(
SELECT 0 UNION ALL SELECT n + 1 FROM seq
WHERE n < DATEDIFF(DAY, @StartDate, @CutoffDate)
)
SELECT n FROM seq