Forum Discussion

chethan's avatar
chethan
Resolver III
9 years ago

Date Duration exclude weekends

Hi All,   i need a DAX formula to calculate the Date Duration by Excluding the Weekends (Saturday & Sunday) Below is the Table View.   TableName : WeeklyReport   Please help on this    Ord...
chethan's avatar
chethan
Resolver III
9 years ago

Hi BhaveshPatel

Thanks for replay.

 

 

I Have Created a Dates Table in your data model But its not working please help me.. Below is the screenprint

 

 

 

Thanks 

 

Regards,

Chethan K

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Instead of summing the [Date] column in your table you should sum your newly created column [IsWorkDay]

 

*Edit* - It also looks as you have created the [IsWorkDay] in your fact table instead of in the date calendar table. Take a closer look to the proposed solution in the first reply. 

 

Br,

Magnus