Solved: Re: Need help on Calculation -

Anonymous · ‎11-15-2022

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 · ‎11-16-2022

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

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

BA_Pete · ‎11-16-2022

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

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Anonymous · ‎11-16-2022

Let me try this @BA_Pete , Thanks for your update

Need help on Calculation -