Home Forums Power BI Tracking and Adjusting Targets using Power Query

Tagged: ,

This topic contains 2 replies, has 2 voices, and was last updated by  manchovick 3 months, 2 weeks ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #12009

    Jacey_Riley
    Participant
    • Started: 15
    • Replies: 15
    • Total: 30

    Hi all,

    I’m currently working with a fairly large data set (a sample of which is provided in the link below).

    I am tracking the number of respondents to a survey, and have created a “have/required” report (in the targets report), which tracks how many respondents we have and the number of respondents that were required for a particular group (gender, race, age, etc…)

    I have highlighted a few cells in red, as those indicate overages; in other words, we have over collected.

    I’m wondering whether there is a way to omit overages, so that it stops tracking at the required number of participants.

    For example, if we have 4/3 (4 being the number we’ve collected, and 3 the amount we actually needed), is there a way to stop the process at 3/3, so extra cases don’t get counted in the report?

    Basically, I would like cell B21, for example, to read 3/3, even though there are more respondents, I would like to adjust/restrict the quotas to no more than what the denominator is set at, so that the numbers won’t show any overages

    Hopefully I’ve explained the issue clearly enough! Any help would be greatly appreciated!

    Currently using Office 365 Pro Plus

    #12010

    Jacey_Riley
    Participant
    • Started: 15
    • Replies: 15
    • Total: 30
    #15466

    manchovick
    Participant
    • Started: 0
    • Replies: 1
    • Total: 1

    Powerful Knowledge.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.