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

[imran_uridetech]

Hi There,

I am trying to create a calculated column to identify certain records in my Dax database in excel PowerPivot.

The calculated column function as follows:

ColumnName = SWITCH(TRUE(),

        CALCULATE(COUNTROWS(fData_Al_Time),

                    FILTER(fData_Al_Time,fData_Al_Time[Calced_Class]="Successful"),

                    FILTER(fData_Al_Time,fData_Al_Time[ID]=EARLIER([ID])),

FILTER(fData_Al_Time,fData_Al_Time[Completed Time]<=(EARLIER([Completed Time])+Time(8,0,0)))||

FILTER(fData_Al_Time,fData_Al_Time[Completed Time]>=(EARLIER([Completed Time])-Time(8,0,0))))>0,"Yes","No")

There are couple problems in this function,
first the error of True / False inside calculate & also the processing time is very slow as I have around 2 million rows.

Any help is appreciated.

[DimaMD]

hi @imran_uridetech Can you provide sample data?

[imran_uridetech]

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

[imran_uridetech]

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