Categories
kidemli-tarihleme uygulama

Make and handle affairs in Power BI desktop computer

Make and handle affairs in Power BI desktop computer

You can easily undertake this example yourself:

  • Duplicate the subsequent ProjectHours desk into a succeed worksheet (excluding the name), identify the cells, immediately after which pick put >Table.
  • From inside the generate desk dialog container, select okay.
  • Choose any desk cellular, identify desk build >Table term, after which submit jobhrs.
  • Carry out the same for your CompanyProject desk.
  • Import the data using attain information in electricity BI pc. Select the two dining tables as a data origin, and then select burden.
  • The most important table, ventureseveral hours, is actually accurate documentation of work tickets that record the quantity of hours an individual has done a certain task.

    ProjectHours

    This 2nd dining table, CompanyProject, try a listing of works with a designated priority: A, B, or C.

    CompanyProject

    Notice that each table possess a venture column. Each is known as a little different, but the values seem like theyre the same. Thats vital, and really make contact with it around quickly.

    Since we have the two dining tables imported into a model, let us create a study. The very first thing we should bring may be the few several hours published by task priority, therefore we identify consideration and several hours from the areas pane.

    When we evaluate our very own table into the document material, youll start to see the wide range of hrs try 256 per venture, coincidentally the total. Obviously this quantity isnt correct. Exactly Why?