Adding a column in date table

Hi jan0204 

Just as Idrissshatila and sayaliredij post that it should work fine.

But if your initial slicer's logic is filter by only one day, when you change it into Qty-year, the error could be caused.

You'd better re-write the measure.

Or if you change the field which you used in the measure an the begining into the new column(Qtr-year column), the Data-type are different of these two field.

It's better if you can provide more detailed description of what you did, or provide some sample data. It would be helpful to find out the solution.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.