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
Chewdata's avatar
Chewdata
Icon for Responsive Resident rankResponsive Resident
2 years ago

Not Sure if I fully understand the case, but maybe this can put in the right direction:

You can make a Power BI Parameter - numeric value -> name: Demodate, min = 0, max = 1, increment = 1. Then it will act like a sort of switch.

Then create measure:
DateToUse = IF(Demodate[Value] = 1, [DateOptionOne], [DateOptionTwo])

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

This is interesting ... I'll give this a try in the next day or two ... I'm hoping that I can use the LocalNow() and Today() in those formulae ... but I quite like this ... elegant if it works.