Forum Discussion

AAbdelkader's avatar
AAbdelkader
Icon for Helper I rankHelper I
9 years ago

There's not enough memory to complete this operation. when creating a measure

Hello,   please I need help as I tried to apply a DAX measure to get MAXIF result, but I get this error    There's not enough memory to complete this operation. Please try again later when there ...
Show and Tell
AAbdelkader's avatar
AAbdelkader
Icon for Helper I rankHelper I
9 years ago

vanessafvg

 

sorry it still loading more then give me the mentioned error, I need to clarify what the result that I need to get, regardless the used equation, you could try an easier one. 

 

 

we will override the query that I applied, I've 2 columns [Code] has duplicated records, [Avail Time] has multiple records for such code, I need [Max Avail] column, I need to get the maximum avail record for every [Code] value then return the other to be 0 like listed in pic

 

thanks a lot,

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

AAbdelkader so this might be a dumb question why dont you group by thee relevant fields ie code date etc and then get the max time.

 

so in other words in power query, create the composite key that makes the code unique by creating a custom column and then group by that key and bring max the max available time, or am i misunderstanding your requirement?