Hi all
I have given the task to create a visual for our company.
As an explanation
We have several departments numbered:
611,612,614,615,616,617,618 and 619
I need a KPI that tells me the average delivery start time from the moment our cargo arrives into port (ETA)
I have used the below measure
Avg Days =
AVERAGEX(
'Table',
DATEDIFF('Table'[ETA], 'Table'[DELIVERY START], DAY))
But For some departments I get no output, please see the evidence below. So i basically want a measure that can calculate the average from the difference but not taking in consideration null or blank values or 0 as it will not give me a true average. I need the measure to take in consideration only the cells that have a date value. I hope I am clear
I have given the task to create a visual for our company.
As an explanation
We have several departments numbered:
611,612,614,615,616,617,618 and 619
I need a KPI that tells me the average delivery start time from the moment our cargo arrives into port (ETA)
I have used the below measure
Avg Days =
AVERAGEX(
'Table',
DATEDIFF('Table'[ETA], 'Table'[DELIVERY START], DAY))
But For some departments I get no output, please see the evidence below. So i basically want a measure that can calculate the average from the difference but not taking in consideration null or blank values or 0 as it will not give me a true average. I need the measure to take in consideration only the cells that have a date value. I hope I am clear