Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |