Forum Discussion

comish4lif's avatar
comish4lif
Helper II
8 years ago

Column reference... cannot be used with a variation 'MonthNo' because it does not have any

I have a measure that was working previously, but is no longer working after a data refresh. The following function:   Requests Completed by Month = COUNTX(FILTER('Production Approval Workflow', 'P...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi comish4lif

 

You could try to change the formula to:

Requests Completed by Month = COUNTX(FILTER('Production Approval Workflow', MONTH('Production Approval Workflow'[Date_Prod_Val_Review]),[Title])

So in stead of: Table[date.column].[MonthNo]  --> MONTH(Table[date.column])