Forum Discussion
RogerN
7 years agoFrequent Visitor
Create a log over order bank - incremental refresh?
Hi, I am trying to create a log over the changes in the order bank in our ERP-system. I have managed to get the current order bank but i would like to be able to save the old values and add the ne...
v-yuta-msft
Community Support
7 years agoRogerN ,
"
I've managed to do it in excel and power query but it involves appended querys that are referencing themselves.
I haven't figured out how to do that in Power BI.
"
Could you share sample data?
Regards,
Jimmy Tao
RogerN
7 years agoFrequent Visitor
i don't think i could share the data, unfortunately.
but the date is the sales order values, from the Sales Lines_table in Dynamics NAV