You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Member Formula for to Date for a View Dimension

Received Response


Greetings, I have a need to create member formulas for members within a View dimension (MTD, QTD, YTD, YTD[Year to Go]).

Content (required):

The databases will have the dimensions, Week, Day and Month (period). The member formulas I think will need to calculate the view based on the week in the month (like an If member is x, then week1+week2. There will be for BSO and ASO cubes. I am just not sure. I have not used Planning for a BI tool with weekly and daily information. Any help is appreciated. Thanks in advance.

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!