Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Memory Allocation failure . Try simplifying or reducing the number of Queries

Hi,   I've had a file in the service for quite a while now (over a year) and just recently I started getting the following error.  I've made any big recent changes especially to the number of queri...
Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago
    Hi there

    I am certain that the above could be created in Power Query

    I would suggest starting to learn Power Query, it will help solve a lot of data challenges you might face.

    And there is a lot of free and paid resources on the web for Power Query training and learning.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ok, I have confirmed that it is a new created table causing the problem.  But I confess I'm not that good with Power Query.  The DAX I am using to create the table is

 

Inv Summary Col = SUMMARIZECOLUMNS('Item Value New'[Item Ledger Entry Quantity], 'Item Value New'[Posting Date],
"Bal Qty", CALCULATE(SUM('Item Value New'[Item Ledger Entry Quantity]), FILTER(ALL('Item Value New'[Posting Date]), 'Item Value New'[Posting Date]<=MAX('Item Value New'[Posting Date] ) ) ),
"Bal Cost", CALCULATE(SUM('Item Value New'[Cost Amount (Actual)]) , FILTER(ALL('Item Value New'[Posting Date]) , 'Item Value New'[Posting Date] <= MAX('Item Value New'[Posting Date] ) ) )
)

Can I do that in power query?

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

I am certain that the above could be created in Power Query

I would suggest starting to learn Power Query, it will help solve a lot of data challenges you might face.

And there is a lot of free and paid resources on the web for Power Query training and learning.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Ok, I will put learning power query after I'm done reading "The Definitive guide to Dax".

     

    Thanks,