Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
Unofrnutultey I can't find opened thread for this issue.
All I'm trying to use is if the function and the return value are true should be the date column -1 day if false return the same day.
At first, I try to use:
if [Hour]>=0 and [Hour]<=5 then [Date]-1 else [Date]
But true value returnins if fales (because formating of the statemtn won't match )
The i try :
if [Hour]>=0 and [Hour]<=5 then Text.From(DateTime.Date(Date(Date.AddDays([Date],-1)))) else [Date]
Unfortunutelly still have error.
Please help!
Solved! Go to Solution.
Hi @Deimantas ,
This should work:
if [Hour] >= 0 and [Hour] <= 5 then Date.AddDays([Date], -1) else [Date]
Pete
Proud to be a Datanaut!
Hi @Deimantas ,
This should work:
if [Hour] >= 0 and [Hour] <= 5 then Date.AddDays([Date], -1) else [Date]
Pete
Proud to be a Datanaut!
Thank you for your replay, it's working!
Thanks.