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.
Applicable88 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.