Forum Discussion

lbudack's avatar
lbudack
Advocate III
4 years ago
Solved

Add Week End Dates to Staff Table

I have a staff table that I need to add week end dates to per staff member. I have tried changing relationships to my existing date table and creating new columns, but for some reason, I am not getti...
Need Help
  • serpiva64's avatar
    serpiva64
    4 years ago

    Hi,

     

    to have it in Power query you can:

    - duplicate your date table and filter it to have only WeekEnd (in your case you want Friday)

     

    - then in your table you add a custom column referring the name of the query of your filtered date table

    - expand custom column

    - now expand custom table

    - change type yo date

    and that's done

     

    If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

     

     

     

serpiva64's avatar
serpiva64
Solution Sage
4 years ago

Hi,

 

to have it in Power query you can:

- duplicate your date table and filter it to have only WeekEnd (in your case you want Friday)

 

- then in your table you add a custom column referring the name of the query of your filtered date table

- expand custom column

- now expand custom table

- change type yo date

and that's done

 

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

 

 

 

lbudack's avatar
lbudack
Advocate III
4 years ago

Thank you! This is exactly it and very straightforward! One of these days I'll be able to logically step through this in my head.