cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sathiyen Regular Visitor
Regular Visitor

Display recent data in table visual (Direct Query Mode)

Hello,

 

I have a Dataset for a day which contains sensor data generated for each five minutes.

I need to display recent sensor data in table visual.

Am using Direct Query mode.

I tried Max function but those are not accepted in direct query mode. Please suggest an alternate solution to this.

1 ACCEPTED SOLUTION

Accepted Solutions
sathiyen Regular Visitor
Regular Visitor

Re: Display recent data in table visual (Direct Query Mode)

Hi @v-shex-msft ,

 

I just thought of trying a workaround, added a coloumn in sql query itself, the column will have binary data 0 or 1 based on the timestamp.

 

I have used the same column to filter it in visual. It worked.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Display recent data in table visual (Direct Query Mode)

Hi @sathiyen ,

You can consider writing a measure formula to get last record id based on categories and conditions, then use this value to compare with current row contents to return tag. (Y/N) Then you can apply this measure on the 'visual level filter' to filter unmatched records.
If you confused about coding formula, please share some sample data with minimum data structure and expected result for the test.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
sathiyen Regular Visitor
Regular Visitor

Re: Display recent data in table visual (Direct Query Mode)

Hi @v-shex-msft ,

 

Thanks for your reply, I guess the measure will work if we need to display only one record.

 

But in my case I need to display multiple parameters values which is generated recently from the sensor.

 

So atleasat there are 10 Parameters, for which data is generated for evey 2 minutes. Please let me know if I create a measure will it work for multiple Parameters.

sathiyen Regular Visitor
Regular Visitor

Re: Display recent data in table visual (Direct Query Mode)

Hi @v-shex-msft ,

 

I just thought of trying a workaround, added a coloumn in sql query itself, the column will have binary data 0 or 1 based on the timestamp.

 

I have used the same column to filter it in visual. It worked.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,904)