Forum Discussion
Solved
New column in DAX
I have two columns: ID Creation Date 1 26.07.2023 09:30:05 2 26.07.2023 12:35:32 3 26.07.2023 15:44:22 4 26.07.2023 17:34:05 5 27.07.2023 08:54:09 6 ...
Hi Mateusz00 ,
You can create the calculated columns as below to get it:
NextDtime = VAR _index = ROUNDUP ( 'Table'[ID] / 3, 0 ) - 1 RETURN ( DATEVALUE ( MIN ( 'Table'[Creation Date] ) ) + _index ) & " " & TIME ( 9, 0, 0 )New Date = IF ( 'Table'[Creation Date] >= 'Table'[NextDtime], 'Table'[Creation Date], 'Table'[NextDtime] )Best Regards
