DAX Calculated Column (in Excel Power Pivot) Returns not enough memory for calculations

Question

Hi There,&nbsp;I am trying to create a calculated column to identify certain records in my Dax database in excel PowerPivot.&nbsp;The calculated column function as follows:&nbsp;ColumnName = SWITCH(TRUE(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE(COUNTROWS(fData_Al_Time),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER(fData_Al_Time,fData_Al_Time[Calced_Class]="Successful"),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER(fData_Al_Time,fData_Al_Time[ID]=EARLIER([ID])),FILTER(fData_Al_Time,fData_Al_Time[Completed Time]&lt;=(EARLIER([Completed Time])+Time(8,0,0)))||FILTER(fData_Al_Time,fData_Al_Time[Completed Time]&gt;=(EARLIER([Completed Time])-Time(8,0,0))))&gt;0,"Yes","No")&nbsp;There are couple problems in this function,first the error of True / False inside calculate &amp; also the processing time is very slow as I have around 2 million rows.&nbsp;Any help is appreciated.&nbsp;&nbsp;

dimamd · Answer

hi&nbsp;imran_uridetech&nbsp;Can you provide sample data?

imran_uridetech · Answer

https://www.dropbox.com/scl/fi/ong5ww9evf2ezkseac83t/SampleData.xlsx?dl=0&amp;rlkey=axqoyxti3kr1wf8s1wmdxbwuf

imran_uridetech · Answer

DimaMD&nbsp;The sample file has been shared as a link.Did you manage to have a look.

Forum Discussion

DAX Calculated Column (in Excel Power Pivot) Returns not enough memory for calculations

3 Replies

Related content

MoM calculation

Calculation Help

Calculate Tooltips

Hour Calculation

How to make a DAX calculation return BLANK rows