The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, i need help,
I used that function on Excel:
=SE(E(I2<=1;L2="B";M2="B");"Título(s) em aberto/Sem limite de crédito";
SE(E(I2<=1;L2="B";M2="A");"Sem limite de crédito";
SE(E(I2<=1;L2="B";M2="");"Sem limite de crédito";
SE(E(I2<=1;L2="A";M2="B");"Título(s) em aberto/Sem limite de crédito";
SE(E(I2>=1;L2="B";M2="A");"Limite de crédito excedido";
SE(E(I2>=1;L2="B";M2="B");"Título(s) em aberto/Limite de crédito excedido";
SE(E(I2>=1;L2="A";M2="B");"Título(s) em aberto";
SE(E(I2>=1;L2="B";M2="");"Limite de crédito excedido";
I used Excel on portuguese, so you can replace "SE" for "IF" and "E" for "AND".
How i do that in Power BI?
(If you guys need more information, just tell me, please).
Tks!
Solved! Go to Solution.
Hi @Anonymous ,
Below you will see an IF AND statement use && for AND.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
Below you will see an IF AND statement use && for AND.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
That work!!! tks so much.
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
20 | |
15 | |
14 | |
10 | |
7 |