Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Calculate value on specific time range from another table

Hi, All

 

I would like to calculate some values(from PLC data) on specific time range(Excel report).

When I query data from PLC, it shows values with timestamp. Even I can calculate but it is not that meaningful.

Because we need to check whether it is dayoff or not on that time.

 

So, I would like to select specific time range based on the Excel report, then I hope to calcuate values with PLC data

 

here are the structures of Two data sets(PLC, Excel)

 

<PLC data : this value could be ideal time// trouble time> 

PLC_value.PNG

<Excel report : it shows start time and end time>

start_end_time.PNG

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

Not sure what you want.

Can you provide your expected result for further investigation?

 

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

Hi, 

Thank you for reply!

I just uploaded some pictures to make it understand better

 

soykms_0-1656303791542.png

 

 

soykms_1-1656303827892.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.