Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Target Value settings

  • 1.  Target Value settings

    Posted Nov 14, 2019 02:40 AM
      |   view attached
    Team,

    Please look into attached document and advise how can set target value aganist an employee..

    ------------------------------
    Unais T K
    DC ADministrator
    ------------------------------

    Attachment(s)

    docx
    targetvalue.docx   209K 1 version
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Target Value settings

    Top Contributor
    Posted Nov 14, 2019 01:03 PM
    Hi Unais !

    You need to connect your EMP_Target table to Date dimension table as well so targets will be loaded based on date criteria

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Target Value settings

    Posted Nov 15, 2019 01:05 AM
    Hi Hashim,

    thanks for update..

    i have invoice header table and invoice line item table.. invoice header table having finanancial year and invoice line item table having sales mana aganist each item sales.. target is based on financial year and sales man in target table.. if i made relation with invoice line item aganist sales man but while adding target am not getting filter by finanacial year its showing total of target aganist sales man..

    ------------------------------
    Unais T K
    DC ADministrator
    ------------------------------

    Academy - Online Interactive Learning from Experts