Forum Discussion
FIltering Data by Samples per second
Hi I'm working with a large data set that captures data constantly. I am wondering how to go about filtering the data to only show 2 samples per second instead of every sample that I get in that seco...
Anonymous If the data is in a relational database eg: SQL Server, then write a custom SQL Query while importing to filter the records (sample 2 records) per second by using RANK. Otherwise, you can also create a new calculated rank column in PBI itself. Anyway, sample data and expected output will help us to understand more details to suggest an accurate solution.