I'd like to be able to create reusable functions in DAX, instead of using the same DAX code in multiple measures. Example: I have some complicated DAX code, which calculates the no of working second...
Feature: similar to Reporting Services, ability to save the function at the Company level, Report Level...
Example: for fiscal calendar, i could write a function Fiscal_SamePeriodLastYear(), and the whole company could use it.
A function could be:
- independent of the Semantic model, in which case it may be easy to store at the company level or report level,
eg1: f(x) = x * x,
eg2: SamePeriodLastYear of a 4-4-5 calendar that can be computed based on math rules only
- or dependent of the Semantic model, in which case it may be more difficult to make available at Company Level, eg: SamePeriodLastYear based on a Calendar that cannot be computed by math only as it needs a specific Calendar table
Report Level storage/availability would be a minimum.
Thanks
