Share via

error not enough memory to complete this operation

Umidvar 5 Reputation points
2023-12-14T20:13:31.78+00:00 
I wanted to created a new column to get numbers per product depending on date column in Power BI Desktop but it gives error not enough memory to complete this operation. I have also replaced EARLIER() with variables but it shows the same error. How can I fix it?

Column = CALCULATE(
    COUNTROWS(Task),
FILTER(Task,Task[Date]<=EARLIER(Task[Date])),
FILTER(Task,Task[Task Name]=EARLIER(Task[Task Name])),
FILTER(Task,Task[Index]<=EARLIER(Task[Index])))

Variable version = 
var Tarix = Task[Date]
var Name = Task[Task Name]
var Indeks = Task[Index]
RETURN
CALCULATE(COUNTROWS(Task),ALL(Task),
Task[Date]<=Tarix && Task[Task Name]=Name && Task[Index]<=Indeks
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
236 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,425 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 6,340 Reputation points Microsoft Vendor
    2023-12-15T02:06:47.8266667+00:00

    Hi @Umidvar

    Since your issue is related to Power BI, it's recommended to post a new thread in Microsoft Power BI Community.

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.