HI All
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 and the formula that needs conversion to DAX is written in Column L. (Just place your cursor on cell L10 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 on cell L10 (This needs conversion to DAX)
=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
)
)
)
Attachments:
You must be
logged in to view attached files.