Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Anonymous
Not applicable

sum columm with condition

Hi guys,

I have trouble do to a task here

I do this

PabloSosa_0-1639416392287.png


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
PabloSosa_1-1639416743846.png

 

Look the return i have sum + 23 in every line

Thank you

 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Anonymous 

 

You can try the following methods.

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

vzhangti_0-1639626584608.png

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.

View solution in original post

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @Anonymous 

 

You can try the following methods.

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

vzhangti_0-1639626584608.png

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.

parry2k
Super User
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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.