[FONT="]Hi,[/FONT]
[FONT="]
[/FONT]
[FONT="]I have the following calculated column, that will calculate correctly and quickly.[/FONT]
[FONT="]
[/FONT]
[FONT="]Column1 = CALCULATE(
COUNTROWS(Query1),
FILTER(Query1,Query1[STATUS]="LN"),
FILTER(Query1,Query1[VALID]="VALID"),
FILTER(Query1,Query1[LOGIN_TIME]=Date[START]))[/FONT]
[FONT="]
[/FONT]
[FONT="]As soon as I change the calculated column to the following I get not enough memory errors and it never calculates.[/FONT]
[FONT="]
[/FONT]
[FONT="]Column1 = CALCULATE(
COUNTROWS(Query1),
FILTER(Query1,Query1[STATUS]="LN"),
FILTER(Query1,Query1[VALID]="VALID"),
FILTER(Query1,Query1[LOGIN_TIME]>=Date[START]))
[/FONT]
[FONT="]
[/FONT]
[FONT="]I really need the calculation to be >=. How can I re-write the calculation so that it will actually calculate?[/FONT]
[FONT="]
[/FONT]
[FONT="]I have the following calculated column, that will calculate correctly and quickly.[/FONT]
[FONT="]
[/FONT]
[FONT="]Column1 = CALCULATE(
COUNTROWS(Query1),
FILTER(Query1,Query1[STATUS]="LN"),
FILTER(Query1,Query1[VALID]="VALID"),
FILTER(Query1,Query1[LOGIN_TIME]=Date[START]))[/FONT]
[FONT="]
[/FONT]
[FONT="]As soon as I change the calculated column to the following I get not enough memory errors and it never calculates.[/FONT]
[FONT="]
[/FONT]
[FONT="]Column1 = CALCULATE(
COUNTROWS(Query1),
FILTER(Query1,Query1[STATUS]="LN"),
FILTER(Query1,Query1[VALID]="VALID"),
FILTER(Query1,Query1[LOGIN_TIME]>=Date[START]))
[/FONT]
[FONT="]
[/FONT]
[FONT="]I really need the calculation to be >=. How can I re-write the calculation so that it will actually calculate?[/FONT]