Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
smjzahid
Helper V
Helper V

Excel formula to DAX

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 formual bar within Excel File)

 

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

 

PlanStart = 08/12/2018

Plan Finish = 04/01/2019

 

 

 Here is the formula written in Excel Workbook 

=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
        )
    )
)

Excel Formula.jpg

6 REPLIES 6
smjzahid
Helper V
Helper V

Hi @smjzahid,

 

I cannot access the file you shared, could you please share it again?

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @v-frfei-msft

 

I cannot share the access level as it is a one drive for business account. Is there a different way through which it can be shared please

 

Thanks

Hi @smjzahid ,

 

Dropbox is also fine.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
smjzahid
Helper V
Helper V

Hello 

 

Just to let you know that, I cannot attach excel or CSV file as an attachment, when I try to do it, the forum says (Incorrect File Type). I have given a try to both type of files (Excel and CSV) Please let me know if you guys need further understanding on converting this formual to DAX.

 

Many Thanks.....

Hi @smjzahid,

 

Please upload your file to One Drive and share the link here.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.