tableau equivalent for datediff

[Nidhi_Kochrekar]

Hello, I am new to powerbi, and need help to convert tableau query to powerbi.

IFNULL({ FIXED [ID]:avg(DATEDIFF('second',[Submit Date],[Incident Resolve Date]))},0)

where [ID] is text

[v-xiaoyan-msft]

Hi @Nidhi_Kochrekar ,

I'm not quite sure if I understand your needs accurately.
Sample data without sensitive information and expected output would help tremendously.
Please see this post regarding: 

How to get your question answered quickly 

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Nidhi_Kochrekar 

Not familiar with tableau syntax, can you explain what exactly is needed with an example?