Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to make a simple statment that checks if it is the current day based off of my calendar.
But our day starts at 3am and ends at 3am the next day. So with this formula if the current date is the 26th, TODAY() is the 26th, but as midnight rolls over and the date changes to the 27th, TODAY() becomes the 27th. What I want is for it to stay the 26th until 3am on the 27th.
What would be the best way to solve this problem?
Solved! Go to Solution.
subtract 1/8 from your datetime value.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.