Forum Discussion
DAX Calculated Column for Last Delivery Date
Thanks for the PBIX-File
At the beginning it seems right, but was not working in my Dataset after implementing.
I used your PBIX-File and added few new rows with new customer_No.
I attched the picture with additional Data to check why calculation is breaking after new customer entry
Hi Power-CJ ,
I am very sorry, I have modified my program, please try again.
Column =
VAR _1 =
CALCULATE (
MAX ( 'Table'[Index] ),
FILTER (
ALL ( 'Table' ),
'Table'[Index] < EARLIER ( 'Table'[Index] )
&& 'Table'[Sell-to-Customer] = EARLIER ( 'Table'[Sell-to-Customer] )
)
)
VAR _2count =
CALCULATE (
COUNT ( 'Table'[Shipment Day] ),
FILTER (
'Table',
'Table'[Shipment Day] = EARLIER ( 'Table'[Shipment Day] )
&& 'Table'[Sell-to-Customer] = EARLIER ( 'Table'[Sell-to-Customer] )
)
)
VAR _shang2 =
CALCULATE (
MIN ( 'Table'[Index] ),
FILTER (
'Table',
_2count > 1
&& 'Table'[Sell-to-Customer] = EARLIER ( 'Table'[Sell-to-Customer] )
&& 'Table'[Shipment Day] = EARLIER ( 'Table'[Shipment Day] )
)
)
VAR _nextday =
CALCULATE (
MAX ( 'Table'[Shipment Day] ),
FILTER (
'Table',
'Table'[Sell-to-Customer] = EARLIER ( 'Table'[Sell-to-Customer] )
&& 'Table'[Index] = _1
)
)
RETURN
IF (
_2count > 1
&& 'Table'[Index] = _shang2,
_nextday,
IF ( _2count > 1 && 'Table'[Index] <> _shang2, BLANK (), _nextday )
)
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
no problem - thanks a lot for the optimizing of the code.
I have problems to implement the DAX-Code in a calculated Column.
After some time PBI break up, becaus of limited capacity.
My Table in the Dataset has about 150.000 rows.
I think the DAX Code is to complex for big Tables.