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 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

Need Help

1 Reply

  • 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