Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Using the First Value Of a Group

  • 1.  Using the First Value Of a Group

    Bronze Contributor
    Posted 29 days ago


    Below is what I am trying to accomplish.

    • Use the cost for the first vendor in the grouping, where the "As Of" date selected falls w/in the Effective/Expiration range.
    • Grouping is by Category/Subcategory/Cost Code
    • Needs to work with the slicer selections
    • Tried RANKX and TOPN, neither with the desired results.


    Link to the pbix example:


    Thank you in advance,

    Curtis Mobley
    Scottsdale AZ