Completing information in the table Power BI

Anything related to PowerPivot and DAX Formuale
jeffer3d
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 PR_HIST_MOVIM_PEDID
Image

Table LOG
Image

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:
Image

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

How to achieve the final result?

MattAllington
Posts: 993
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Completing information in the table Power BI

Postby MattAllington » Sun May 27, 2018 7:18 am

I recommend you read my article here https://exceleratorbi.com.au/best-pract ... -power-bi/

I find it hard to advise you because what you are showing is a long way from what I would recommend you starting with.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 5 guests