Forum Discussion

warrenpoh's avatar
warrenpoh
Frequent Visitor
9 years ago
Solved

Data Modeling with Timesheets

Hi,   I am trying to model some timesheet data that both looks at the timesheet transactions themselves AND compares and creates metrics using information not in the transactions table.   Ideal O...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi @warrenpoh，

     

    You can create a table using the DAX below.

    Summrize = SUMMARIZE(STALL,STALL[StaffName])

     

    Then add some calculated column like:Hours Worked TOTAL YTD = CALCULATE(SUM(STALL[HoursWorked]),FILTER(ALL(STALL),STALL[StaffName]='Summrize'[StaffName]))Invoiced TOTAL YTD = CALCULATE(SUM(STALL[InvoicedValue]),FILTER(ALL(STALL),STALL[StaffName]='Summrize'[StaffName]))

     

    If this is not what you want, please provide us more information, if possible provide us some cample data and screenshots, so that we can make further analysis.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi @warrenpoh，

 

You can create a table using the DAX below.

Summrize = SUMMARIZE(STALL,STALL[StaffName])

 

Then add some calculated column like:Hours Worked TOTAL YTD = CALCULATE(SUM(STALL[HoursWorked]),FILTER(ALL(STALL),STALL[StaffName]='Summrize'[StaffName]))Invoiced TOTAL YTD = CALCULATE(SUM(STALL[InvoicedValue]),FILTER(ALL(STALL),STALL[StaffName]='Summrize'[StaffName]))

 

If this is not what you want, please provide us more information, if possible provide us some cample data and screenshots, so that we can make further analysis.

 

Regards,

Charlie Liao

  • warrenpoh's avatar
    warrenpoh
    Frequent Visitor
    9 years ago

    Thanks Charlie