Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
5 years ago
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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Applicable88's avatar
    Applicable88
    5 years ago

    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. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Applicable88 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
5 years ago

amitchandak, I sent you the link to the sample data in your message inbox. 

Thank you.

Best.