Forum Discussion

Mateusz00's avatar
Mateusz00
Frequent Visitor
3 years ago
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    ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    hello i tried your response and it works , iwas wondering if you could help me add 1 hour between each meeting , lets say i can only take 1 meeting at a time, how can i add 1 hour difference 

    expected result

    Meeting Schedule

    7/26/2023 9:30:05 AM
    7/26/2023 12:35:32 PM
    7/26/2023 3:44:22 PM
    7/27/2023 9:00:00 AM
    7/27/2023 10:00:00 AM
    7/27/2023 11:00:00 AM
    7/28/2023 9:00:00 AM
    7/28/2023 10:00:00 AM
    7/28/2023 11:00:00 AM
    7/29/2023 9:00:00 AM