topic Change DAX calculated column using EARLIER Function in DAX Commands and Tips

Change DAX calculated column using EARLIER Function

jludwick — Tue, 16 Apr 2024 23:12:54 GMT

Hello,

I recently read that you should not use the EARLIER function. I recently inherited a dataset file that uses this function and it keeps crashing, likely due to the EARLIER function. I am trying to convert this formula into the proper format using variables but I'm having some trouble.

The current code is set up like so to get the cumulative balance as of the most recent invoice. How can I adjust this to remove the EARLIER function but get the same result?

_Balance Cumulative = calculate(sum(Invoices[Balance]), ALLEXCEPT(Invoices,Invoices[Customer ID + Company Desc]), filter( all(Invoices[Invoice Date]),Invoices[Invoice Date] <= EARLIER(Invoices[Invoice Date])))

Re: Change DAX calculated column using EARLIER Function

Anonymous — Wed, 17 Apr 2024 06:41:26 GMT

Hi jludwick ,

If you want to create a calculated column, you can try:

_Balance Cumulative = var _a=Invoices[Invoice Date] return calculate(sum(Invoices[Balance]), ALLEXCEPT(Invoices,Invoices[Customer ID + Company Desc]), filter( all(Invoices[Invoice Date]),Invoices[Invoice Date] <= _a ))

If you want to create a measure, you can try:

Best Regards,

Neeko Tang

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

Re: Change DAX calculated column using EARLIER Function

ThxAlot — Wed, 17 Apr 2024 05:26:39 GMT

In a calculated column, it's highly recommended to use VAR to subsitute for EALIER/ERLIEST for better readability and maintainability,

_Balance Cumulative = VAR __dt = Invoices[Invoice Date] RETURN CALCULATE( SUM( Invoices[Balance] ), ALLEXCEPT( Invoices, Invoices[Customer ID + Company Desc] ), Invoices[Invoice Date] <= __dt )