Display recent data in table visual (Direct Query Mode)

[sathiyen]

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.

[v-shex-msft]

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

[sathiyen]

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 · Accepted solution]

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.