Forum Discussion

Ayush_Mittal's avatar
Ayush_Mittal
Frequent Visitor
10 years ago

Power Bi equivalent of FirstSortedValue ({<$(vProjectsActive)>} [Project Address],

The code mentioned was from a QV but now I want to achiev a similar functioning in Power BI. what should I do??
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Can you describe you data and what you are trying to accomplish? Looks like you are sorting a column by another column and then grabbing the first value?? In the example below, are you sorting Project Address or vProjectsActive or what are those things? Is vProjectsActive a view/table?

Ayush_Mittal's avatar
Ayush_Mittal
Frequent Visitor
10 years ago

Here I'm Filtering the table by Project Address. Whereas the vProjectActive is the check for active Project.