Most RecentNewestMost VotedMost ViewedConvert the start time and end time into multiple rows with 30 minutes interval Sometimes we may want to add one row every 30 minutes (or other intervals) between the start time and end time in xxx table. Through this blog, I will show you how to do it using M query and DAX. Skip null values to add index columns This is an article about how to skip null values to add index columns. Tips for handling common scenarios of employee attendance sheets Tips for handling common scenarios of employee attendance sheets