POWER BI Time Sheet Report

(0) Share

Report

Posted on by Reller

Can anyone offer insight on how to successfully create a power BI report based on resource time sheet entries? I have been able to create only based on the current timesheet, but would like the functionality to select archived Timesheets and display entry details.

The attached image is the layout I am looking for - in this example, the current timesheet for one resource is being displayed as that is the only resource using TS in this demo. Ideally, as more resources have timesheets, there will be more columns with the viewer able to filter by TS ending date (Primarily Archived or both current and archived if possible)

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 152 on at

Like (0)

Report
Copy link

Link copied!

The tables are identical in terms of fields so just a case of having a web service for archive and active time sheets. Power query wise you can merge the table data so power bi sees it as one data set: docs.microsoft.com/.../table-combine

Was this reply helpful? Yes No