Completing information in the table Power BI

[JeffersonSouza3]

Hi Everyone,

I was hoping someone could help me with a part of the formula to get me to my end goal.

Table PR_HIST_MOVIM_PEDID

Table LOG

PR_HIST_MOVIM_PEDID table has order status per day, but when you turn the month, it loses information. A LOG table has one last transition of each request per day and it is this table that is the correct reference. I have to create a new table that shows me all the requests and their days without losing information as soon as the birthday turn-over happens.

Example:

NOTE: Notice that this is a small example. My database table has tens of thousands of values.

How to achieve the final result?

[v-piga-msft]

Hi @JeffersonSouza3，

I'm a little confused about your scenario, could you share me your example sample which can reproduce the scenario and your expected output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry