Forum Discussion
jan month data
hiii i was calculating waiting tym <30secs for january but i am getting a error i have a table called month with january, febuary and march months data in it
jan month =
CALCULATE(
COUNTROWS('Phone Call Data'),
FILTER(
'Phone Call Data',
TIME( HOUR('Phone Call Data'[waiting tym]), MINUTE('Phone Call Data'[waiting tym]), SECOND('Phone Call Data'[waiting tym]) ) < TIME(0,0,29) && MONTH('Phone Call Data'[Month].[March]= 1
)
))
Anonymous , is this a date 'Phone Call Data'[Month].[March] or 'Phone Call Data'[Month].
It should be like 'Phone Call Data'[Month]. =1
or if it a date
month('Phone Call Data'[Month]) =1
It is Month text then you have used
'Phone Call Data'[Month] ="January"
2 Replies
jan monthimage = CALCULATE( COUNTROWS('Phone Call Data'), FILTER( 'Phone Call Data', TIME( HOUR('Phone Call Data'[waiting tym]), MINUTE('Phone Call Data'[waiting tym]), SECOND('Phone Call Data'[waiting tym]) ) < TIME(0,0,29) && MONTH('Phone Call Data'[Month]= 1 ) ))Anonymous , is this a date 'Phone Call Data'[Month].[March] or 'Phone Call Data'[Month].
It should be like 'Phone Call Data'[Month]. =1
or if it a date
month('Phone Call Data'[Month]) =1
It is Month text then you have used
'Phone Call Data'[Month] ="January"
