Using the First Value Of a Group

  • Using the First Value Of a Group

    Posted by DSC Communities on June 2, 2022 at 5:47 pm
    • Curtis Mobley

      Member

      June 2, 2022 at 5:47 PM

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

    DSC Communities replied 3 years, 10 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Using the First Value Of a Group’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!