Hey guys!
I'm trying to map some logic using if then else.I have column "Date" and column "Duration".If the value for Duration is> 0.08: 00: 00 and it is between Mon-Fri, then 0.08: 00: 00 should be mapped.If the value is> 0.10: 00: 00 and it is between Sat-Sun then 0.10: 00: 00 should be displayed. Otherwise, the original value.
As I understand it, this would be:
if and then else if and then else
Date.DayOfWeek [Date] <= 4 and [Duration]> #duration (0, 08, 00, 00) then #duration (0, 08, 00, 00) else if Date.DayOfWeek [Date]> 4 and [ Duration]> #duration (0, 10, 00, 00) then #duration (0, 10, 00, 00)
Do you have any suggestions?
Best regards
I'm trying to map some logic using if then else.I have column "Date" and column "Duration".If the value for Duration is> 0.08: 00: 00 and it is between Mon-Fri, then 0.08: 00: 00 should be mapped.If the value is> 0.10: 00: 00 and it is between Sat-Sun then 0.10: 00: 00 should be displayed. Otherwise, the original value.
As I understand it, this would be:
if and then else if and then else
Date.DayOfWeek [Date] <= 4 and [Duration]> #duration (0, 08, 00, 00) then #duration (0, 08, 00, 00) else if Date.DayOfWeek [Date]> 4 and [ Duration]> #duration (0, 10, 00, 00) then #duration (0, 10, 00, 00)
Do you have any suggestions?
Best regards