Condition in the edit query

[SRK_23]

Hi, i've an issue with a table (KPI) that is too huge to load, how can I add a condition saying: 

"load the data after January 1st 2018 only" ?

Thanks

[v-danhe-msft]

Hi @SRK_23,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @SRK_23,

From your picture, I have noticed that you are using SSAS database, if so, you could edit DAX formula before you impored your data:

EVALUATE
FILTER ( Sheet2, Sheet2[Date] >2018/1/1 )

Result:

You could also refer to this link:

https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/

Hope it could help you.

Regards,

Daniel He