Forum Discussion
Log data.
Dear All,
I have a DirectQuery Connectivity where I can see the status of work orders live. Now this status changes continuously to open, pending or ready. I would now like to record this status of the work orders, for example weekly? How can I do this. Through a data flo trought data
Hi Jwij ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
3 Replies
Jwij , you have created a weekly snapshot for that. Storage mode will import
You have to use DAX union for that
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/Hi Jwij ,
I think you want to create a column in Power BI for last refresh date.
Please kindly refer to:
https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jwij ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
