Doug the data guy on 23 Mar 2016 23:04:03
Users want to use any metric against a set of time that is dynamic. Thus, we'd like to have calculated members so we can create YTD or MTD or same week last year or any time set that can be used with any metric. Currently the functions force the model to put YTD with one metric and to do YTD with a different metric, you have to define it as a new measure. We want to apply these calculated members against any measure. Apparently calculated members can be created in MDX but not in DAX, which is more used in Power BI modeling.
- Comments (4)
RE: "calculated members"
The work around for this is to build a "Time Period" table with dates in it. Then when a user selected the "YTD" time period, it will show all dates in the time period. It's not perfect but the nice thing about this is that it applies automatically to all measures.
RE: "calculated members"
Support to Calculated Members in Dimension that can be created is SSAS Multi Dimensional Cube is must, showing any YTD, MTD, QTD, YoY etc. side by side with Months members in Grid or Matrix view is not possible in current versions of Power BI
RE: "calculated members"
I agree, this is a must!
RE: "calculated members"
Power BI does not support calculated members created in a multi-dimensional cube in Analysis Services. They do not show up. This needs to be changed!