I have a pretty simple question that I am sure has an easy answer and I am simply trying too hard to figure it out.
Lets say I have a measure Price. And I want to display the minimum Price. That is easy enough. But if I also want to display a corresponding dimension, say Company Name, how do I go about that? The actual example is a bit more complicated with groupings by other dimensions such as Region.
So my approach was the get the index of the lowest price such as:
Min Index = if min([Price]) = window_min(min([Price]), first(), last()) then Index() end
Then use this value, the Index into the table where the lowest price is found to get the company name.
I have included a very basic sample. Thanks for help anyone can provide.
So I may have solved it. At least I did so in my slimmed down example. Ranked by Price in ascending order. Then grabbed the name of the Company where Rank = 1. Hoping this approach can work in my complex data set.
For what it is worth, I am guessing there is any easier way to do this.