Forum Discussion
How do i create a date table ?
I was trying to create a date table for filtering.. And ran across this DAX (below) ... thinking it looked useful. However when I went to create the table and use it.. Didn't seem to work.. e...
Thanks Giles , this is awesome and very helpful .. :-)
one more question ..
of all of these filters below i am getting the following error :
+/- 1 months = IF(AND(DateKey[Financial month number]>=[Current financial month]-1,DateKey[Financial month number]<=[Current financial month]),1,0)
"A single value for column 'Date' in table 'DateKey' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
sbowles Are you entering the formula as a measure or a column? It needs to be inserted as a column, I think this may be the issue.