jan month data

[Anonymous]

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

    )

))

[amitchandak · Accepted solution]

@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"

[FarhanAhmed]

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   )
))