Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @FJ83 ,
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
Proud to be a Datanaut!
Hi @FJ83 ,
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |