Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create Calculated Column with Conditions

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? ...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Ashish_Mathur
Super User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago


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's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      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's avatar
        Ashish_Mathur
        Super User
        4 years ago

        Hi,

        Try this calculated column formula

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