Improve advance filtering for datatime to support relative periods
Improve advance filtering for datatime to support relative periods. For example I want to display only last hour of information from a Stream Analytics source. ASA hopping window is a period of 30 seconds, but ASA cannot filter and remove old data (older than one hour). Power BI should have smart filtering ability like PQ YTD/MTD, last <X> <TimePeriod>, etc.
Marius Strom commented
+1 for this. In addition, I'm stumped because I have a report where I need to see rows of data that are aged. I can't see a way to do a relative filter to say to return results before "1 year ago" for example. It would be great if PowerBI used operators similar to Azure Data Explorer as a north star.
(currently I'm considering a workaround where I add a calculated column to my data to indicate the record is >1 year old, but that seems... inelegant.)