Forum Discussion

sulleyinoz's avatar
sulleyinoz
Icon for Advocate II rankAdvocate II
2 years ago

Create a Demo Date and Time based on Today() and DateTime.LocalNow()

EDIT:  I need to set a FIXED DATE and a FIXED DATETIME in a variable as though I was showing the system from 18months ago ... I don't need a slider that will cause chaos and confusion to end users.  ...
Need Help
sulleyinoz's avatar
sulleyinoz
Icon for Advocate II rankAdvocate II
2 years ago

Still don't have a reasonable answer for this one ... anybody?

 

  • dk_dk's avatar
    dk_dk
    Icon for Super User rankSuper User
    2 years ago

    If you are able to add tables to your model, you could create a table with DAX, Power Query, or the Enter Data option, that would only contain one column and one row, with the value being set to the date you want to use in the demo. Make sure the column is in the correct date format.

    Then you can make a DemoDate = MAX(Table[Column]), and reference that for the demo, and Today() for the live deployment.

    Let me know if this works for you, or if I maybe misunderstood your use case?