Same calculated column in Power Pivot and PBI, different result

[russtak]

Hi All

my table in power pivot is (and the data that I'm expecting....)

Date	Prev Date (calculated column)
3/08/1984
4/08/1984	3/08/1984
5/08/1984	4/08/1984
9/08/1984	5/08/1984
10/08/1984	9/08/1984

The calculated column's code is

=CALCULATE(MAX(Table1[Date]),FILTER(Table1,EARLIER(Table1[Date])>Table1[Date]))

 Similar table in Power BI is

Date	Prev Date (calculated column)
03/08/1984
06/08/1984	03/08/1984
07/08/1984	06/08/1984
08/08/1984	07/08/1984
15/08/1984	14/08/1984

This calculated column code is 

Prev Date = CALCULATE(MAX(aord[Date]),FILTER(aord,EARLIER(aord[Date])>aord[Date]))

 Why the difference ?

tks Russell

[Nathaniel_C · Accepted solution]

Hi @russtak ,
Well, for one thing, the first column is different in the two scenarios. We would really need to see the underlying tables to go further.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[russtak]

Hi @Nathaniel_C

The difference in the data in the 'Date' column is irrelevant, I wanted to show that the 'Prev Date' field  for the 5th row in the PBI table  is incorrect should be showing 08/08/1984 and not 14/08/1984. In any case to demo it properly I changed the data in the power pivot query  to align with power bi.

Power Pivot Data below, 5th record shows correct Prev Date as 8/08/1984

Date	Prev Date
3/08/1984
6/08/1984	3/08/1984
7/08/1984	6/08/1984
8/08/1984	7/08/1984
15/08/1984	8/08/1984

[russtak]

Hi @Nathaniel_C 

Noob issue my csv data was dodgy, thanks for your help

tks R