Forum Discussion

melanie-g's avatar
melanie-g
Frequent Visitor
4 years ago

Date table issue

Hi there   I have a table called Date which lists out the start and end date for each month. I added a custom column so that it lists every date. I then created a Workdays (excluding weekends and p...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

HI melanie-g ,

Could you pls share your pbix file ,and remember to remove confidential data.

 

 

 

Best Regards

Lucien

  • melanie-g's avatar
    melanie-g
    Frequent Visitor
    4 years ago

    Hi v-luwang-msft 

    Thanks for your response. 

    Please see below link to files.

     

    I have kept all of the date tables but removed the confidential data. I have added a "test" Dealership table and Sales table so you can see how my real model actually looked.

     

    I want to be able to have "State" in a slicer that calculates the correct work days, work days passed and work days remaining depending on what State is selected. Each state should generate different days as they have some different public holidays.

     

    Thanks. 

     

    https://www.dropbox.com/scl/fo/38fdzxggsjppvkf8jf4o3/h?dl=0&rlkey=ouapt6t5k4ov3ydfcmrjqmfrd