Forum Discussion

janhaviqut3009's avatar
janhaviqut3009
Frequent Visitor
2 years ago

Power BI custom column

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 ...
Need Help
Show and Tell
janhaviqut3009's avatar
janhaviqut3009
Frequent Visitor
2 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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