cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smjzahid Frequent Visitor
Frequent Visitor

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 Frequent Visitor
Frequent Visitor

Re: Excel formula to DAX

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.....

Community Support Team
Community Support Team

Re: Excel formula to DAX

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 other members find it more quickly.
smjzahid Frequent Visitor
Frequent Visitor

Re: Excel formula to DAX

Community Support Team
Community Support Team

Re: Excel formula to DAX

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 other members find it more quickly.
smjzahid Frequent Visitor
Frequent Visitor

Re: Excel formula to DAX

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

Community Support Team
Community Support Team

Re: Excel formula to DAX

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 other members find it more quickly.