Forum Discussion

yios's avatar
yios
Helper I
5 years ago

Dax calculated column optimization

Hi all,   I have created a calculated column with the below dax code Previous Val = var _date = MyTable[Date] var _label = MyTable[label] var _IssueDateTime = MyTable[IssueDateTime] return MA...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi yios ,

Using EARLIER() function like @ amitchandak mentioned is acutally a way to optimize the calculated column in this case. Basically we would suggest you to create measure instead of calculated column to save memory because if the amount of calculation is large, it will take up more memory, resulting in insufficient memory and produce an error like your mentioned. 

You can refer this blog about measure and calculated column:

Calculated-columns-and-measures-in-dax 

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • yios's avatar
    yios
    Helper I
    5 years ago

    Is there any documentation that says that earlier function is faster than using variables ??

    I am asking because it runs in exactly the same time, no better performance.

  • yios's avatar
    yios
    Helper I
    5 years ago

    I tried your proposal to use measure instead of calculated columns but it takes a lot time the visual to be displayed due to complex calculations which must be run on the fly of a user reaction.