Forum Discussion
Change date by time
- 3 years ago
Hi Anonymous
you may try
New Date =
DATEVALUE (
'Table'[2nd Weight Date] + 'Table'[2nd Weight Time]
- TIME ( 6, 0, 0 )
)
I believe I understand this as for any times before 6am, the new date column should show the previous date, for times of 6am or later it should show the 2nd Weight date. Because this is a static property of the 2nd weight, and the 6am changeover time doesn't change, I suggest doing this in PowerQuery.
Here's an expression to do this with a custom column in PowerQuery:
if Time.Hour([2nd Weight Time]) >= 6 then [2nd Weight Date] else Date.AddDays([2nd Weight Date], -1)
Here's the equivalent in DAX for a calculated column, but this would be less performant, so try the above first:
Thanks a lot, but I tried this way and it's not workig.