cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SRK_23 Regular Visitor
Regular Visitor

Condition in the edit query

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

 

image

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Condition in the edit query

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 )

1.PNG

Result:

2.PNG

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

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Condition in the edit query

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 )

1.PNG

Result:

2.PNG

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

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Condition in the edit query

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.