Forum Discussion
Solved
IF AND STATEMENT DATE & TIME
Hi there, I have problem that I can solve in Excel but not in Power BI and I am hoping that someone could help me to figure out a way to solve this. I have three columns: date, time, and even...
Julius410 , Create a new date column and use that for analysis or join with date table
New Date = if([time] <=time(5,0,0), [Date] -1, [Date])
Julius410 , Create a new date column and use that for analysis or join with date table
New Date = if([time] <=time(5,0,0), [Date] -1, [Date])
Thank you!
