Matching system time with table time and display goal value

[Anonymous]

Hello everyone, 

I am trying to get values from a table which has list of time values (e.g, 7:01 am, 7:02 am ...) and against every time value we have  defined goal. How I can extract specific value based on system time and display as KPI ? 

[Anonymous]

If you see there are two reports from different tables. both have time values as current time and time. I want to show current goal value according to system time which updated with system time

You can see these two table reports have time columns. I want to display current goal value on dashboard according to system time

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

I think you may want to see the values based on the system time.

You can achieve your goal by measure.

My Sample Table:

Measure:

System Time = 
VAR _NOW = NOW()
RETURN
TIME(HOUR(_NOW),MINUTE(_NOW),00)

Filter Measure = IF(MAX(Data[Time]) = [System Time],1,0)

Build a table visual and add Filter Measure into Filter Field, set it to show item when values is 1.

My system Time:

Refresh the desktop and it will show the value base on my system time.

You can download the pbix file from this link: Matching system time with table time and display goal value

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

current goal is on left table which have distinct values ending at 4342

[camargos88]

@Anonymous ,

Do you have an example ??

System time = now() ? If yes, you can extract the time from this function and work on it.