Forum Discussion

sanderson82's avatar
sanderson82
Helper I
7 years ago
Solved

Linking dates - Different tables / data sources

Hi I'm working on a report which shows timesheet hours against actual clocked hours from a timeware program. The timesheet is a PowerApp I've created with data stored on a sharepoint list. The time...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    sanderson82 how I know whcih table is which but few ideas.

     

    - make calendar/date dimension in your model and link it with your tables. There are many posts on how to create one.

    - make employee dimension table (unique employee list) and link with your tables.

     

    in all visuals, use date and employee from above dimension and data from your transaction tables and everything will work thru.

     

    Date and employee dimension will be one to many relationship, one on dimension side and many on transaction side.

sanderson82's avatar
sanderson82
Helper I
7 years ago

Thanks parry2k  this is now working.  Just need to figure out how enable selecting a date range, or total for the previous week when a Sunday is selected

parry2k's avatar
parry2k
Super User
7 years ago

sanderson82 it can be achieved by time intelligence DAX function, there are lot of posts on it. If you couldn't figure out, let me know.