I am new to DAX could you please help me convert below written Formula in Excel Workbook to DAX. (as we are migrating to Power BI). I am also attaching sample Excel File for your perusal and the formula that needs conversion to DAX is written in Column L. (Just place your cursor on cell L9 to see the formula in the top formula bar within Excel File)

I provide the details for referenced dates used in below excel formula

PlanStart = 08/12/2018

Plan Finish = 04/01/2019

Here is the formula written in Excel Workbook

{L_CODE}{L_COLON} {L_SELECT_ALL_CODE}

`=IF(`

AND(

MAX(

E258,

F258

) <= PlanFinish,

MIN(

E258,

F258

) >= PlanStart

),

COUNT(

E258:F258

),

IF(

AND(

E258 >= PlanStart,

E258 <= PlanFinish

),

1,

IF(

AND(

F258 >= PlanStart,

F258 <= PlanFinish

),

1,

0

)

)

)

The result that is expected is should be as per column L in below image (highlighted in Red square)

[img]

[/img]

Thanks Everyone in Advance.