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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors