cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brainer13
Regular Visitor

How can I detect how many times a promissed date was changed?

Hello, I am very noob using Power Bi, but so far I've manage to create some simple reports.

I was in a meeting today and one of the managers asked me how many times a committed date was changed? I didn't have the answer at that moment,  but I believe that the data where I create my Power BI report has the answer. As you can see in the picture below for example, the item PDL-5VF (which is the produc) from the order number 13428254 did not change the schedule date (which is the committed date) from 18-Mar to 29-Mar (time this order was open). However, the item CJH6X88TGAW from the order 13439627 changed the schedule ship date two times, first it was 22-Mar and then 30-Mar. 

I would like to tell them how many times an order was changed or how many times an Item number was modified in order to create a Top list of Failures. Any suggestions?

Brainer13_1-1623481880796.png

 

 

3 ACCEPTED SOLUTIONS
AlB
Super User III
Super User III

Hi @Brainer13

Wouldn't just throwing the Item # in a table visual and then a simple measure:

     Measure = DISTINCTCOUNT( Table1[ScheduledDate]) 

do the trick? You might have to include the Order # in the visual too if it is not uniquely determined by the Item #

 

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

View solution in original post

Brainer13
Regular Visitor

Thank you so much AIB for your fast reply. It works😀
I have one more question if you don't mind. How can I see the distinctcount for the orders and items that are still open (pending to send). For example in the top list I got, the first line is already closed, so I want to focus only in the orders that are actually open. If I filter the print date today, the measure changes to 1, so I suppose there should be some way to unfilter the distinctcount.

Brainer13_0-1623514660390.png

 

View solution in original post

Hello Just figure it out how to solve it. I add a calendar table and used the function, CALCULAT('DistinctCountp,ALL('Calendar')
Thank you

View solution in original post

4 REPLIES 4
AlB
Super User III
Super User III

@Brainer13 

What exactly in your data defines an order as open? You can use that filter in a slicer. I need more details

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

AlB
Super User III
Super User III

Hi @Brainer13

Wouldn't just throwing the Item # in a table visual and then a simple measure:

     Measure = DISTINCTCOUNT( Table1[ScheduledDate]) 

do the trick? You might have to include the Order # in the visual too if it is not uniquely determined by the Item #

 

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

View solution in original post

Brainer13
Regular Visitor

Thank you so much AIB for your fast reply. It works😀
I have one more question if you don't mind. How can I see the distinctcount for the orders and items that are still open (pending to send). For example in the top list I got, the first line is already closed, so I want to focus only in the orders that are actually open. If I filter the print date today, the measure changes to 1, so I suppose there should be some way to unfilter the distinctcount.

Brainer13_0-1623514660390.png

 

View solution in original post

Hello Just figure it out how to solve it. I add a calendar table and used the function, CALCULAT('DistinctCountp,ALL('Calendar')
Thank you

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors