Hourly Rate

[tmears]

Hi

I have a column in my table which is the Date and time, what i am looking to achieve is to hightlight only the last hours data.

I would like to display the hours data in a visual, so if i can flag the last hours data, i could use this on a visual level on a gauge.

I presuem it is a IF statement

Hope this makes sense

Tim

[v-huizhn-msft]

Hi @tmears,

First you'd better create a calculated column to get last hour using the following formulas.

1. You can create a calculated column rank to order all yourtime.

Rank=RANKX(Table, Table[hour],ASC)

2. Use Lookup function to get the last hour date.

Last Hour=LOOKUP(Table[hour], Table[Rank],Table[Rank]-1)

Then you create a gauge, which field will be value level and which one is Target level, do you mind post some sample data and detail information?

Best Regards,
Angelia