cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## sum columm with condition

Hi guys,

I have trouble do to a task here

I do this

What i need

when [CodUser] be:

280 ||
621 ||
928 ||
512 ||
284
I want return the columm [jornadaMin] + 23,  if another number i want return [JornadaMin] only

I do this, but don´t work

Look the return i have sum + 23 in every line

Thank you

1 ACCEPTED SOLUTION
Community Support

Hi, @Anonymous

You can try the following methods.

``````JornadaMin2 =
IF (
[CodUser] IN ( { 280, 621, 928, 512, 284 } ),
IF (
[CodUser] IN ( { 1772, 1226, 295, 975 } ),
)
)``````
``````JornadaMin3 =
VAR n2 = [JornadaMin] + 23
RETURN
IF (
[CodUser] IN ( { 280, 621, 928, 512, 284 } ),
n2,
IF ( [CodUser] IN ( { 1772, 1226, 295, 975 } ), adm, n )
)``````

Both formulas can get the results you want.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi, @Anonymous

You can try the following methods.

``````JornadaMin2 =
IF (
[CodUser] IN ( { 280, 621, 928, 512, 284 } ),
IF (
[CodUser] IN ( { 1772, 1226, 295, 975 } ),
)
)``````
``````JornadaMin3 =
VAR n2 = [JornadaMin] + 23
RETURN
IF (
[CodUser] IN ( { 280, 621, 928, 512, 284 } ),
n2,
IF ( [CodUser] IN ( { 1772, 1226, 295, 975 } ), adm, n )
)``````

Both formulas can get the results you want.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@Anonymous what are these measures/columns? You have to be more specific?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.