Forum Discussion

neilmacmullen's avatar
neilmacmullen
Frequent Visitor
8 years ago

Working with time-based IOT data in PowerBi - advice needed

I'm new to PowerBI and struggling mightily to get it to show me 'simple' queries on my data.  I'm used to writing LINQ queries in C# and probably suffering from trying to map this mindset onto DAX....
Need Help
neilmacmullen's avatar
neilmacmullen
Frequent Visitor
8 years ago

Thanks Sam.  The TOPN/MAXX combination looks like the 'missing link' to emulate the OrderBy/FirstOrDefault part of my query.  My next problem is to make this reusable so I can parameterise the table/column names and filter condition.  I suspect this means diving into M and finding equivalents of those operations.  Will post here if I make progress.