Forum Discussion
AdministratorHelp with DAX power BI
Hi Syndicate_Admin , Thank you for reaching out to the Microsoft Community Forum.
Please refer below sample spreadsheet snap:
Detenciones_Limpias snap:
Detenciones_Con_Producción snap:
Please refer attached .pbix file and output snaps and share your thoughts:
Administratorhttps://drive.google.com/file/d/1VQxu75c2BTS5lk_Jti99BGLrE7p8WN5B/view?usp=drive_link
There is the PBI file mentioned, thanks for the suggestions
Super UserThe link requires access. please check.
- Syndicate_Admin
My apologies, I just checked and I have left the file as public.
- lbendlin
Your data seems to be missing the End Date column - how are you planning to handle events that run across midnight?
You may also want to invest in a calendar table.
Identifying the "previous" record is expensive in your scenario (multi million row fact table) and will likely have to be done outside of Power BI. For example with an index column in Power Query.
- Syndicate_Admin
Yes, the truth is that there is no end date, however, when a stop is extended to the next day the "Start date" column is also changed to the next day, so it seems to me that it is not a problem.
Yes, I can make the calendar table but my problem finally (or I think) is how to translate the logic I'm looking for into a DAX or power query (M), of sequentially checking the production database with the stops database