Need help on Calculation -

[Anonymous]

Hi All,

Quick help, please

In the client Cyrstal reporting system, the calculation was defined like this,

IF(IRD.RL_Date) = #12/07/2941 12:00:00 AM"# then 0 

else

Datediff("h",{IRD.Book_Date},{IRD.RL_Date})

Need your help in achieving the same condition in PowerBI? 

[BA_Pete · Accepted solution]

Hi @Anonymous ,

In M code, it would be something like this:

if [IRD.RL_Date] = #datetime(2941, 07, 12, 00, 00, 00) then 0
else Duration.Hours([IRD.RL_Date] - [IRD.Book_Date])

Pete

[Anonymous]

Let me try this @BA_Pete , Thanks for your update