When a report model is autogenerated, default expressions are created for dates and numerics. For example, for date fields, expressions for Day, Month, Year, Quarter, etc.. are created. Is there a way to add a new expression so that it is always generated? For example, I would like a Week expression generated for all date fields. Is this possible? I've also tried manually creating the expression but i can't seem to create it under each attribute. It displays at the same level as the attribute.

Hello QALBI, In your case, I think that we can create the named calculation to achieve your requirement. Please refer to the following steps below: 1. In the Data Source View design surface, right-click on DimDate table and select New Named Calculation. 2. Define the named calculation like this: Column name: Year Description: Calculate the Year for the date. Expression: Year(MyDate) 3. Click OK to close the dialog. Then, we can right-click on the table and select Explore Data to verify the values. Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Bin Long TechNet Community Support

Hello QALBI, In your case, I think that we can create the named calculation to achieve your requirement. Please refer to the following steps below: 1. In the Data Source View design surface, right-click on DimDate table and select New Named Calculation. 2. Define the named calculation like this: Column name: Year Description: Calculate the Year for the date. Expression: Year(MyDate) 3. Click OK to close the dialog. Then, we can right-click on the table and select Explore Data to verify the values. Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Bin Long TechNet Community Support