DAX

[YV]

I created a new column name Quarterly Profit using DAX formula: Quarterly Profit= calculate([Yearly Profit Margin], DATESQTD('calendarTbale'[date])) and it keep gives me errors and say they can't find the column name Yearly profit Margin I created earlier.

[v-tianyich-msft]

Hi @YV ,

Try to add the table name to [Yearly Profit Margin], please provide your sample data to better solve the problem for you.

Best regards,
Community Support Team_ Scott Chang