Solved: Calculate Days between Two Dates excluding weekend...

Anonymous · ‎05-01-2018

Hello All,

I have two Dates for cases,LastTimeStamp and Today(),

LastTimeStamp is most recent date when a case was worked upon,

Today() is the Latest Date,

I want to calculate no. of Days between LastTimeStamp and Today() excluding Weekends,

How can this be done,

kindly help me out on this, i am attaching a image of requirement,

Thanks in advance,

Malav Shelat

Greg_Deckler · ‎05-01-2018

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎05-01-2018

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎05-01-2018

That was a beautiful solution Greg, Thank you so much.

Calculate Days between Two Dates excluding weekends (different Scenario).