Time Intelligence Function Help

[cmajka]

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!

 

[Matt Allington]

Ah yes.