Home Forums Power Pivot Excel Formula To DAX Conversion

This topic contains 0 replies, has 1 voice, and was last updated by  smj.zahid 6 months, 2 weeks ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #12333

    smj.zahid
    Participant
    • Started: 1
    • Replies: 0
    • Total: 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.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.