Difference in last two consecutive values

[IHam]

I have a series of reports (in report time order) that are graded in a variety of categories for an identifier. What I need to do is to identify (using the code) those with consecutive 5 grades (this is the lowest grade) in any category. It is only required to identify those who have scored a 5 in any of the latest set of reports (the highest report time order) and scored a 5 in any of the previous set of reports. Once this is done, they will be highlighted on a table. The report time is dynamic so will be a value 4 at the next set of reports etc.

I have tried a few ways of doing this but it isn't returning the correct value.

Can anyone help?

[v-chuncz-msft · Accepted solution]

@IHam,

You may try using LOOKUPVALUE and CONTAINS to add calculated column.

• https://community.powerbi.com/t5/Desktop/Checking-if-record-was-the-same-in-previous-month/m-p/34138...
• https://community.powerbi.com/t5/Desktop/Comparing-a-month-to-it-s-relative-previous-month-in-a-tabl...

[IHam]

Thanks - I will have a look at those today. One of the issues I had been having was that one person had many entries for the same time and if any of those were a 5, it would want the code to register it as a 5.

thanks for getting back to me.

[IHam]

I figured it out using Vars. many thanks for your help