Forum Discussion
Microsoft EmployeeDate Dimension Table that Dynamically Pulls Start and End dates from a Column of Dates
Microsoft EmployeeThis is a much more elegant solution that is also definitely going to work after publish, as all columns are calculated via DAX. Thanks for finding this.
This is great for Dates. Is there something similar for TIME?
I need to find data associated with a specific short time period, usually 30 minutes to a couple of hours. The start and end times of the period are stored in one table and the data is in another.
Any ideas?
Thank you,
Phil
- dkay84_PowerBI
The Duration.Days step can be changed to hours or mins (https://msdn.microsoft.com/en-us/library/mt296613.aspx)
Everything else should be more or less the same. The step to create a list of all time periods would change from List.Days to List. something else depending on your granularity (https://msdn.microsoft.com/en-us/library/mt296612.aspx)