By Default, a year level was expected. No such level was found in the cube

When you use YTD function in KPI or calculated measures, you might get the error message as “By Default, a year level was expected. No such level was found in the cube”. The reason for this is most of the date dimensions are formed based on pre populated Date Dimension table, so the SSAS Engine itself not able to find the Field which is Year.

The solution for this, have to manually define which Filed is Year filed in Date Dimension table. Simply you can use Business Intelligence Wizard to define the Year filed as shown below.

If not we can define using the field properties “Type” set as relevant Type. The below image shows that a field in the date dimension is been set as Quarter Type.

Cheers!