Help with Date calculations and count of days

[Anonymous]

Hi Team,

I am new to BI and needed quick help to achieve the highlighted columns from the data set below. I have provided the intended outcomes in the last two columns in Blue.

Thanks in advance!

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, you could refer to below steps:

Create a weeknum column:

weekday = WEEKDAY('Table1'[Date of delivery],2)

Create two columns:

Column = [Date of delivery]+ROUNDDOWN('Table1'[SLA]/5,0)*5+ROUNDUP('Table1'[SLA]/5,0)*2+MOD('Table1'[SLA],5)

Actual days = DATEDIFF('Table1'[Date of delivery],[Column],DAY)

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[Anonymous]

Hi @v-danhe-msft ,

Thank you very much for your help. Yes! This is exactly what I was trying to achieve! However, I noticed the 'Actual days' field doesn't exclude weekends. I couldn't proceed further as I also have some other columns and measures to apply based on these values available. Could you please review it once more?

I have attached the screenshot again for your easy reference purpose. Many thanks for your quick help.