Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculating Deadline

Hello Team,

I have a scenarion where i have given date/time stamp and i want to calculate the deadline date/time.

For instance: 12/08/2019 5:16 am is the start date so the end date/time would be 13/08/2019 5:15 am (24 hours from the start date/time), how do we do that?

 

Pleae assist,thanks

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    HI,

    I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.

    It is for creating a new calculated column.

     

     

    End datetime CC = 
Data[Start datetime] +1 - ((1/24)/60)