Member Formula for to Date for a View Dimension
Greetings, I have a need to create member formulas for members within a View dimension (MTD, QTD, YTD, YTD[Year to Go]).
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):