Forum Discussion
Helper IIICalculate column isn't working
Calculate column isn't working
I'm trying to utilize the following function in the image below. It used to work correctly, and now it doesn't the "Cost PR" column does indeed exist, but it shows the column doesn't exist or there is no value for the record. What is the issue withmy syntax?
Thank you,
You are creating a measure but there's no aggregation (SUM, COUNT, etc) on the column.
I'm not 100% sure but I think the error message on this sort of thing used to be different but that looks like the issue.
3 Replies
- HotChilli
Community Champion
You are creating a measure but there's no aggregation (SUM, COUNT, etc) on the column.
I'm not 100% sure but I think the error message on this sort of thing used to be different but that looks like the issue.
vsslasd1Thank you - so how would that be corrected? : Calculate(SUM(column))....?
- vsslasd1
Yes, it seems you got had it exactly on:
This looks like it resolves it:Cost Total Hours LW 2 =CALCULATE(SUM([Cost Total Hours]),FILTER('Date Table',YEAR('Date Table'[Date]) = YEAR(TODAY()) &&WEEKNUM('Date Table'[Date]) = WEEKNUM(TODAY()) - 1))Thank you !