How to create a YTD in the model

[peersbrennanctb]

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 

[N1kh1l · Accepted solution]

@peersbrennanctb 

Add your date dimension either to the table axis ( row/column) or filter but use the default hierarchy of the date. Mostly its YQM.

Nikhil

[peersbrennanctb · Accepted solution]

Thanks that is all I needed to do