DAX for Smarties
Do you know that great feeling when you are struggling to find a formula, spend hours writing non-sense calculations until a light turns into your brain, your fingers move rapidly on the keyboard and, after a quick debug, DAX starts to compute exactly what you wanted? This session shows many of these scenarios spending some time looking at the pattern of each one, discussing the formula and its challenge and, at the end, writing the formula. Scenarios include non-trivial examples, like time intelligence with an ISO-week calendar, budget analysis and comparisons, same period last year with multi selection of non-contiguous periods, distinct count over slowly changing dimensions and others. A medium knowledge of the DAX language will let you get the best out of the session.