Forum Discussion
Solved
Calculation if time falls between 7pm-midnight
Hi I am having trouble getting this to work in DAX. I have a time column and need to calculate a new date based on the time. SO if the time if >7:00:00 PM and < 12:00:00 AM, I need to add one day ...
Hi jenniferhoward ,
1. Create a calculated column by using DAX:
Column = IF([time]>TIME(18,59,59) ,DATEADD('Table'[date].[Date],1,DAY),[date])2. Create a custom column in Power Query:
if [time]> Time.FromText("18:59:59") then Date.AddDays([date],1) else [date]
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jenniferhoward ,
1. Create a calculated column by using DAX:
Column = IF([time]>TIME(18,59,59) ,DATEADD('Table'[date].[Date],1,DAY),[date])
2. Create a custom column in Power Query:
if [time]> Time.FromText("18:59:59") then Date.AddDays([date],1) else [date]
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You're amazing -thanks so much!