Hi All -
I have created a lookup calendar table and am using the following formula, however, I am getting an error:
Total DPW YTD:=CALCULATE([DPW],DATESYTD (dimDate[Date]))
Any suggestions?
The error states...'Semantic Error: the value for 'DPW' cannot be determined. Either 'DPW' doesn't exist, or there is no current row for a column named 'DPW'
I'm not quite sure i understand the time intelligence functions yet, so bear with me.
Thanks!
I have created a lookup calendar table and am using the following formula, however, I am getting an error:
Total DPW YTD:=CALCULATE([DPW],DATESYTD (dimDate[Date]))
Any suggestions?
The error states...'Semantic Error: the value for 'DPW' cannot be determined. Either 'DPW' doesn't exist, or there is no current row for a column named 'DPW'
I'm not quite sure i understand the time intelligence functions yet, so bear with me.
Thanks!