Forum Discussion
shamsuddeenvp
Post Patron
Post PatronHelp to solve the below logic using power bi
Dear, I am trying to build the below logic in powerbi. Can anyone help on this, I tried and able to get the result only one part. Data is about millions, and need to think about performance as we...
shamsuddeenvpPost Patron
Post PatronI had done this using DAX queries.
Br,
Shams
Phil_Seamark
Microsoft Employee
Microsoft EmployeeTo address your performace issues, you need to split your date column in to two columns.
The other should carry the Hour or Minute of the day as an integer. This will make a massive difference over the size of your model and make loading and calculations much faster.
Then you can do the rest in DAX or PQ. When the actions are within 4 hours on the same day it's easy. If they split a day, you just need a basic IF statement to handle that.
If you have millions of rows, you have to avoid having columns that are highly unique like your datetime column.