Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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"
@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"
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 )
))
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |