Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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(     C...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    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's avatar
FarhanAhmed
Community Champion
6 years ago
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   )
))