sum/Average incorrect in calculated column in Power BI desktop

[antara_centri]

Hello All,

I have created a calculated column 

Initial Response Time(Minutes) =

IF(

    ISBLANK('Incidents created after Jan 1 2022'[Initial Response Date]),

    0.00,  

    DATEDIFF(

        'Incidents created after Jan 1 2022'[Created Date],

        'Incidents created after Jan 1 2022'[Initial Response Date],

        MINUTE

    )

)

when I am computing this in a matrix in power BI the sum and average  is coming wrong.I have the same dataset in excel and the sum is different.How do I fix the error in Power BI

Power BI

 Excel:

[mussaenda]

Hi @antara_centri ,

Have you perform any merging on your fact table?

Because it is really strange that they have a big gap.

[Anonymous]

Hi @antara_centri ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@antara_centri , I doubt sum can be wrong in power bi for a calculated column. for better avg you can use blank in place of 0

Initial Response Time(Minutes) =
IF(
ISBLANK('Incidents created after Jan 1 2022'[Initial Response Date]),
blank() ,
DATEDIFF(
'Incidents created after Jan 1 2022'[Created Date],
'Incidents created after Jan 1 2022'[Initial Response Date],
MINUTE
)
)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.