Mark New Added Items PQ or DAX

[ahmedismailfourtex]

Hello,
I had created an report to follow up my orders, this report take the data from database, i would like to mark the new orders witch added after last update by "New*" for example.
my data looks like:

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80"]Order ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl65, width: 113"]Order Date/Time[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80"]Customer[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80, align: right"]25[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl65, width: 113, align: right"]28/10/2017 09:46[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD][TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl65, width: 113, align: right"]13/10/2017 18:30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD][TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl65, width: 113, align: right"]13/09/2017 07:46[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Z[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance.

 

[ImkeF]

There is no concept for this in Power Query, as all data will be loaded on refresh.
You have to store the latest Order/Date/Time somewhere else (in your Excel worksheet or when using PBI, you can use R to export to csv or txt) and reference it in your filter for the next refresh.

 

[ahmedismailfourtex]

There is no concept for this in Power Query, as all data will be loaded on refresh.
You have to store the latest Order/Date/Time somewhere else (in your Excel worksheet or when using PBI, you can use R to export to csv or txt) and reference it in your filter for the next refresh.

Thank you Imke for your help,
I'm already loaded it as a table in the excel, what is the next step?
Appreciate your help.

 

[ImkeF]

You import that back to PQ and create a query "LastValue" with List.Max(YourTable[Order Date/Time]) from it .

Then you add a column to your import-table with sth like this: if [Order Date/Time]<=LastValue then "Old" else "New"

This formula checks if the [Order Date/Time]-value is after the last import and adds "New" otherwise "Old".