Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
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 |
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |