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??

2 Replies

  • 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.