I was hoping someone could help me with a part of the formula to get me to my end goal.
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 of expected result:
NOTE: Notice that this is a small example. My database table has tens of thousands of values.
How to achieve the final result?
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 2 guests