Change the time on a dynamic date

Question

Hello everyone

I'm trying to replicate a column calculated from a Tableau report to Power BI, basically I want to change the time of the dates I just want to change the time for example instead of having started at 07:15:00 a.m to change to 07:00:00 and then be able to take the difference of minutes between what should have been with what it really was.

Below I place the formula that I want to replicate.

TKs!!

lbendlin · Answer

That's not what that formula does.&nbsp; It moves the time either to 7 am or to 7 pm based on Day or Night shift.
&nbsp;
Please provide sample data that covers your issue or question completely. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Change the time on a dynamic date

1 Reply

Related content

Dynamic date/time change

Power Bi Dynamic Time Zone Transformation

Dynamic Time Axis

Date TIme Change

Power BI - Dynamically Change Column Name