Hi I am struggling to create a YTD calculation in the model.
I am using Classic Model
In the formula box: YTD ([sales],[d/date])
When adding the new measure to a table no data is displayed and I am getting the warning displayed below
Dimension not found for field name : Current Member Dimension/Fieldname 'Date' or Hierarchy 'YMD' specified in member 'Account::[Account].[parentId].&[YTD_Sales]' is not in drill.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.