Forum Discussion
Time filtering
Hi everyone I have a transaction table with a few million rows and a date&time column that contains records for several days. Because the data gets pulled at a random time, some of my record...
I think you can construct a new column (adjusted day) which would be a date format (not datetime) and something like:
if hour is less than 6 then subtract 1 day from the date of date&time column else date of date&time
Any idea how to go about writing that formula in Power Query?
I just started working in Power BI not long ago and I'm not that familiar with the language.