Create Calculated Column with Conditions

[Anonymous]

Good morning, I hope you can help me what I want to do in Power Bi in this

If a worker has the number 15 twice (that is, the name is repeated), how can I make a column place the number 2?

If a worker has a value less than 15, give me the number 1

If a worker has 3 times 15, let me have the number 3

Note: All this calculation in a single column as I can do it through the DAX language

[Anonymous]

@Ashish_Mathur 

[Anonymous · Accepted solution]

Hi @Anonymous ,

I think you can try this code to create a calculated column.

Calculated Column with Conditions =
VAR _COUNT_15 =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( ALLEXCEPT ( 'Table', 'Table'[NOMBRES] ), 'Table'[LIQ] = 15 )
    )
VAR _COUNT_Lessthan_15 =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( ALLEXCEPT ( 'Table', 'Table'[NOMBRES] ), 'Table'[LIQ] < 15 )
    )
RETURN
    IF ( _COUNT_Lessthan_15 = 1, 1, _COUNT_15 )

Result is as below.

Best Regards,
Rico Zhou

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

[Ashish_Mathur]

Hi,

See if this calculated column formula works

Count = calculate(countrows(Data),filter(Data,Data[Nombres]=earlier(Data[Nombres])&&Data[LIQ]=earlier(Data[LIQ])))

Hope this helps.

[Anonymous]

Good morning, is that formula to create a calculated column or a measure? I want to create a calculated column with those conditions.

[Ashish_Mathur]

Hi,

As mentioned in my earlier message, mine is a calculated column formula.

[Anonymous]

Thank you very much, but the formula only prints the duplicate results, that is, if there are 2 duplicates, it gives me the number 2 or if there are 3, it gives me the number 3

But I want that if the number is If a name has 2 times 15, I want to put the number 2

If it is less than 15, let me put 1

[Ashish_Mathur]

Hi,

Try this calculated column formula

Calc = if(Data[LIQ]<15,1,if(Data[Count]=2,2,""))