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