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:

Order ID <tbody> </tbody>	Order Date/Time <tbody> </tbody>	Customer <tbody> </tbody>
25 <tbody> </tbody>	28/10/2017 09:46 <tbody> </tbody>	X
26	13/10/2017 18:30 <tbody> </tbody>	Y
27	13/09/2017 07:46 <tbody> </tbody>	Z

<tbody>
</tbody>

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".