Forum Discussion
Solved
Date function in nested If-statement, but changing after certain time
Hello, I tried many ways to calculate a dynamic time problem, but the calculated column in M language giving me trouble. I use following if statement: if ([deliverydate]<=Date.From(DateTime.Loca...
Found my solution. Defintely add another time function base on the system now() time where it compares what time of the time range it is at automatic dataset refresh. So that it will use the right nested statement according to the time of today.
Found my solution. Defintely add another time function base on the system now() time where it compares what time of the time range it is at automatic dataset refresh. So that it will use the right nested statement according to the time of today.