Power BI custom column

[janhaviqut3009]

I have two columns Current 1 and Current 2, i want the custom column to start with 0's and increment to 1, 2,3... when the conditions are true in both the columns and the conditions are when Current 1 =0 and Current 2 >0. Ideally i want my custom columns to look like 000000011112222233333444..... and increment each time the condition is met

[janhaviqut3009]

Hi, thank you for your code! It says theres not enough memory to complete this operation. Please try again later when there may be more memory available?

[v-heq-msft]

Hi @janhaviqut3009 ,
This problem may be caused by insufficient system resources, such as low random access memory (RAM) or a slow computer processor. You can fix this error by freeing up memory in Power BI by closing other applications and processes. If the data model is too complex or contains unnecessary data, it can strain system resources and cause the application to crash.
To optimize the data model, first remove any unnecessary columns or tables. You can also try splitting large tables into smaller ones or using filters to limit the amount of data loaded into memory.
Additionally, consider using calculated columns instead of metrics, as they are less resource-intensive and can improve performance and reduce the risk of memory allocation failures.

You can refer to this document
How to Fix Memory Allocation Error in Power BI Desktop - Monocroft

Best regards,
Albert He

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

[v-heq-msft]

Hi @janhaviqut3009 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Open power query and add a index column

Close and apply then create columns

Result = 
IF(
    'Table'[Current 1] = 0 && 'Table'[Current 2] > 0,
    1,
    0
)

Outpput = 
CALCULATE(
    SUM('Table'[Result]),
    FILTER(
        'Table',
        'Table'[Index] <= EARLIER('Table'[Index])
    )
)

Final output

Best regards,
Albert He

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