Forum Discussion

RachelN's avatar
RachelN
Regular Visitor
6 years ago
Solved

Group by Week for multiple tables

Hi guys,   I hope you are all safe during this time. I'm a new Power BI user and hope that you can help me with the best approach to solve this.   I have three table name Timesheet (include Staf...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi RachelN ,

     

    We can try to create a calendar dim-table to connect other tables and use WeekNum column of it as the row of visual:

     

    CalendarTable =
ADDCOLUMNS ( CALENDARAUTO (), "WeekNum", WEEKNUM ( [Date] ) )

     

    We can also Create Staff dim-table by using following dax:

     

    Staff =
DISTINCT (
    UNION (
        DISTINCT ( 'Timesheet'[Staff Name] ),
        DISTINCT ( 'Trello Work'[Staff Name] ),
        DISTINCT ( 'Non-Trello work'[Staff Name] )
    )
)

     


    Best regards,

     

  • RachelN's avatar
    RachelN
    6 years ago

    Hi v-lid-msft amitchandak, thank you so much for your kind support! I've achieved the outcome that I want for my data. I really appreciate your help!

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi RachelN ,

 

We can try to create a calendar dim-table to connect other tables and use WeekNum column of it as the row of visual:

 

CalendarTable =
ADDCOLUMNS ( CALENDARAUTO (), "WeekNum", WEEKNUM ( [Date] ) )

 

We can also Create Staff dim-table by using following dax:

 

Staff =
DISTINCT (
    UNION (
        DISTINCT ( 'Timesheet'[Staff Name] ),
        DISTINCT ( 'Trello Work'[Staff Name] ),
        DISTINCT ( 'Non-Trello work'[Staff Name] )
    )
)

 


Best regards,

 

  • RachelN's avatar
    RachelN
    Regular Visitor
    6 years ago

    Hi v-lid-msft amitchandak, thank you so much for your kind support! I've achieved the outcome that I want for my data. I really appreciate your help!