Forum Discussion

tmears's avatar
tmears
Helper III
9 years ago

Hourly Rate

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 ...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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