Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Converting Excel Formula to Dax

Hi 

 

Bit of a different one wondered if anyone could provide the DAX equivalents? 

 

I have this formula in excel; 

SUMPRODUCT(MID(0&CE2,LARGE(INDEX(ISNUMBER(--MID(CE2,ROW($1:$1),1))* ROW($1:$1),0),ROW($1:$1))+1,1)*10^ROW($1:$1)/10)

 

Does anyone have an idea the DAX compatible version? 

 

Thanks

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey Anonymous 
    I think it is better that you will provide a sample data, requirements and expected result(s).

    It is much easier than trying to translate a formula.

    Cheers!
    A