Calculate the number of weeks between the two date rows

Anonymous — Wed, 20 Oct 2021 07:44:09 GMT

Hi,

I need to calculate the number of weeks between the two date rows based on the category start date and finish date as shown below

Re: Calculate the number of weeks between the two date rows

Anonymous — Fri, 22 Oct 2021 09:01:51 GMT

Hi Anonymous

Try to use datediff function in your code.

Weekdiff = VAR _T = SUMMARIZE ( 'Table', 'Table'[SDCCode], "Weekdiff", VAR _LoadStartDate = CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( 'Table', 'Table'[Category] = "03.WO Load Start Date" ) ) VAR _LoadFinishDate = CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( 'Table', 'Table'[Category] = "04.WO Load Finish Date" ) ) RETURN DATEDIFF ( _LoadStartDate, _LoadFinishDate, WEEK ) ) RETURN SUMX ( _T, [Weekdiff] )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Calculate the number of weeks between the two date rows in Developer

Calculate the number of weeks between the two date rows

Re: Calculate the number of weeks between the two date rows