Forum Discussion

Rocha2001's avatar
Rocha2001
New Member
4 years ago
Solved

Convert Excel formula to DAX

Hi, 

As I'm fairly new to Power BI I have a formula in Excel which I would like some help on how to use in Power BI, please.    The formula is as follows: 

 

=IF(AND(Family="#";Cod pos="3400100";C cost="14000G";OR(LEFT(Text;3)="Ana";LEFT(Text;3)="RAP"));"RAPPEL";

IF(AND(Family="#";Cod pos="3400100";C cost="14000G");"Present";

IF(OR(AND(Family="#";Cod pos="3401001");AND(Family="#";Cod pos="3401003");AND(Family="#";Cod pos="3400100";C cost="140TC"));"Store";

IF(AND(Family="#";Cod pos="3400100";VALUE(C cost)>0);"RAPPEL";IF(AND(Family="#";Cod pos="3301001");"MOV";

IF(OR(VALUE(Family)=197;VALUE(Family)=198);"MOV";

IF(VALUE(Family)<=196;"Store";"")))))))

 

Thank you all!

1 Reply