Forum Discussion
Need help on Calculation -
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?
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
