topic Re: DAX Calculation to retrieve the entry before in DAX Commands and Tips

DAX Calculation to retrieve the entry before

MWare — Wed, 02 Nov 2022 21:48:06 GMT

Hi,

Looking for some help please.

I am trying to return the previous 'Sale time' based on the 'Sales Person' of each row in my 'Sales' table.

Unfortunatley the index is based on all sales in the shop and thus I can't use -1 on the index as the Sales Person can vary.

See below image in Power BI, the DAX formula I have created using EARLIER in column 'Prior Sales Time (DAX Help)' is not returning the prior sales time for the sales person for the row. See the 'Prior Sales Time (the answer I'm after)' column for what the value I'm expecting in my DAX formula.

Any ideas?

Re: DAX Calculation to retrieve the entry before

wdx223_Daniel — Thu, 03 Nov 2022 01:32:35 GMT

=MAXX(FILTER(Sales,Sales[Sale Person]=EARLIER(Sales[Sale Person])&&Sales[Sale Time]<EARLIER(Sales[Sale Time])),Sales[Sale Time])

Re: DAX Calculation to retrieve the entry before

MWare — Thu, 03 Nov 2022 14:40:50 GMT

Perfect! thank you very much!