calculating duration between max and min dates in two columns

[mohammadyousaf]

Hi, I have two columns 

Col. A                 Col. B

1-Jan 2020         10-Jan-2020

3-Mar-2020        3-Apr-2020

15-Aug-2020      5-Sep-2020

7-Jan-2020         15-Jan-2020

11-Feb-2020       12-Apr-2020

10-Nov-2020      07-Jan-201

I want to take the Min date of Col. A and Max date of Col B. to calculate total duration. I have case where smallest date in Col. A is the start date and Max Date in Col B. is the end date. 

Any help is appreciated. 

[mohammadyousaf]

worked perfectly, thank you... 

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@mohammadyousaf 

pls try this

Measure = DATEDIFF(min('Table'[Col.A]),max('Table'[Col.B]),DAY)