Excel Formula To DAX Conversion

[smj.zahidParticipant Started: 1Replies: 0Total: 1]

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.

[Author]

Posts