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

    Hello,

    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.

     

    curtismob_0-1646336133269.png
    Link to the pbix example:

    https://drive.google.com/file/d/19svDZp3xEVu44yePjN6rCWKIDbdXnhly/view?usp=sharing

    Thank you in advance,
    Curtis



    ------------------------------
    Curtis Mobley
    Scottsdale AZ
    4803486029
    ------------------------------