Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

DIFFERENCE OF DAYS WITH NETWORKDAYS EXCLUDING DUPLICATE VALUES

NEEHola, guys

I am trying to calculate the difference of days between the two dates with Networkdays, however what I am looking for is by means of a formula to calculate the difference excluding the repeated values in column #Guia, that is to say that the last rows of the table should only take me 1 since the rest is repeated as a result of the same case.

# GuideStart DayClosing Day
00040000602513/4/20235/5/2023
00040000603718/4/20233/5/2023
00040000604821/4/20235/5/2023
00040000605121/4/20233/5/2023
00040000605724/4/20238/5/2023
00040000606424/4/20233/5/2023
00040000606626/4/202310/5/2023
00040000606726/4/20235/5/2023
00040000606826/4/20239/5/2023
00040000606926/4/202316/5/2023
00040000607026/4/202316/5/2023
00040000608226/4/202315/5/2023
00040000608226/4/202315/5/2023
00040000608226/4/202315/5/2023
00040000608226/4/202315/5/2023
00040000608226/4/202315/5/2023
00040000608226/4/202315/5/2023
00040000608226/4/202315/5/2023
1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

Now if I could solve you gave me an idea the formula is like this:

Days of attention test =
AVERAGEX(
SUMMARIZE(Claims;Claims[Notice];Claims[Claim Start Date];Claims[Claim Closing Date]);
NETWORKDAYS(Claims[Claim Start Date];Claims[Claim Closing Date]))

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Now if I could solve you gave me an idea the formula is like this:

Days of attention test =
AVERAGEX(
SUMMARIZE(Claims;Claims[Notice];Claims[Claim Start Date];Claims[Claim Closing Date]);
NETWORKDAYS(Claims[Claim Start Date];Claims[Claim Closing Date]))
Syndicate_Admin
Administrator
Administrator

It does not work xq what you are summarizing is the dates and not considering the # of Guia, what I should do is summarize the repeated guides and calculate on the dates that remain.

amitchandak
Super User
Super User

@Syndicate_Admin , Try a measure like

 

Sumx(summarize(Table, Table[# Guide], Table[Start Day], Table[Closing Day]), networkdays(Table[Start Day], Table[Closing Day], 1))

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.