Forum Discussion
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!
Rocha2001 , with correct column names try with Switch
Switch(True() ,
([Family]="#" && [Cod pos]="3400100" && [cost]="14000G" && (LEFT([Text];3) ="Ana" || LEFT([Text];3)="RAP") ) ;"RAPPEL" ;
[Family]="#" && [Cod pos]="3400100" && [cost]="14000G";"Present";
//Add otherconditions"" //Default value
)Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
1 Reply
- amitchandak
Super User
Rocha2001 , with correct column names try with Switch
Switch(True() ,
([Family]="#" && [Cod pos]="3400100" && [cost]="14000G" && (LEFT([Text];3) ="Ana" || LEFT([Text];3)="RAP") ) ;"RAPPEL" ;
[Family]="#" && [Cod pos]="3400100" && [cost]="14000G";"Present";
//Add otherconditions"" //Default value
)Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56