Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there anyway to fine tune this or use Measures to achieve this New_Return Column?
I've got 7 Columns in this table and query works with filter till 2017 May 1st and beyond that throws error "There's Not Enough Memory To Complete This Operation"
Running on 16GB and upgrading is not an option, my boss doesnt want to spend money 😞
New_Return=
VAR rule1 =
CALCULATE (
COUNTROWS ( Table1 ),
FILTER (
ALLEXCEPT ( Table1, Table1[cust_num] ),
Table1[order date] < EARLIER ( Table1[order date] )
)
)
VAR Calc =
CALCULATE (
MIN ( Table1[order date] ),
FILTER (
ALLEXCEPT ( Table1, Table1[cust_num] ),
Table1[order date] < EARLIER ( Table1[order date] )
)
)
VAR rule2 =
IF ( NOT ( ISBLANK ( Calc ) ), DATEDIFF ( Calc, Table1[order date], DAY ) )
RETURN
IF ( OR ( rule1 = 0, rule2 > 100 ), "New", "return" )
)
My initial post is here
Any suggestions would be greatly appreciated
Thank you
Van
Solved! Go to Solution.
So after few failures i found this is the best way to do it, created new table with only 3 columns and used the same DAX calculation and it refreshes in less than 30 sec.
Cheers
Van
Have you tried to remove the filters?
Column = VAR rule1=CALCULATE(COUNTROWS(Table1),ALLEXCEPT(Table1,Table1[cust_num]),Table1[order date]<earlier(Table1[order date])) VAR Calc=CALCULATE(min(Table1[order date]),ALLEXCEPT(Table1,Table1[cust_num]),Table1[order date]<earlier(Table1[order date])) VAR rule2=if(NOT(ISBLANK(Calc)),DATEDIFF(Calc,Table1[order date],DAY)) RETURN IF(OR(rule1=0,rule2>100),"New","return")
Thanks for our reply, Yes i did try removing filters, no luck. I cant believe this calculation is talking up 16 GB!
There should be something that i can tune , ill update if I find any solution.
Thank you
Van
So after few failures i found this is the best way to do it, created new table with only 3 columns and used the same DAX calculation and it refreshes in less than 30 sec.
Cheers
Van
Hi Van,
I realize this was a while ago, but I am facing the same issue now. What columns did you use for your new table and did you join it to your original table?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |