Completing information in the table Power BI

Anything related to PowerPivot and DAX Formuale
Posts: 1
Joined: Mon Apr 30, 2018 9:57 pm

Completing information in the table Power BI

Postby jeffer3d » Mon Apr 30, 2018 10:01 pm

Hi Everyone,

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


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 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?

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests