Compare value to value 15 minutes piror

[ps80538]

I am trying to compare a value to its previous value which is recorded 15 minutes prior in the data model. Additionally, I have several different employees which can be considered categories by which I need to filter the comparison. So, in short, I need to filter by a category “‘Em;ployee Name” and then be able to compare a performance metric to the previously interval’s value of the performance metric. It is easy to do this using date intervals, but cannot figure out how to do this when the interval is down to 15 minute resolution.

[pranamg]

@ps80538

are a value to its previous value which is recorded 15 minutes prior in the data model. Additionally, I have several different employees which can be considered categories by which I need to filter the comparison. So, in short, I need to filter by a category “‘Em;ployee Name” and then be able to compare a performance metric to the previously interval’s value of the performance metric. It is easy to do this using date intervals, but cannot figure out how to do this when the interval is down to 15 minute resolution.

You can either create an Interval Calendar in Power Query or use DAX Functions.

How to categorize and group data in time intervals with Power Query - Data...

Creating 15 Minute intervals from Date and Time Column

Group interval 15 min by value

How to create a Time Table to analyze your Power BI or Excel data

[ps80538]

Thank you for responding but I am not sure the suggested solutions address my issue. The interval is recorded in 15 minute increments already. I do believe I need to artificially group the data in 15 minute groupings. I am trying to understand how to compare the current filtered value to the one from its previous interval.

[ps80538]

Additionally, I’d prefer to do this entirely through DAX and not create additional unnecessary columns. I do not want to bog down the model response time.

[ps80538]

Another way to look at it - I would like to create the same functionality of the PREVIOUSDAY DAX function but instead of previous day, look at the previous minute (15 in this case) interval.

[Keith]

did you go through the dax guide? I don’t see any kind of function time Previous time in dax guide

[ps80538]

I have been through the guide and I have not found anything to help.

[ankit]

Hi @ps80538 - Please share a sample PBIX file to analyse further.

Thanks
Ankit J

[EnterpriseDNA]

Hi @ps80538, we’ve noticed that no response has been received from you since June 28th. We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

[EnterpriseDNA]

Hi @ps80538, due to inactivity, we’ll be marking this post as solved.

Should you wish to reopen this thread, kindly provide the PBIX file requested above so other users can help you further.