Forum Discussion

curiouspbix0's avatar
curiouspbix0
Helper IV
7 years ago
Solved

Next Working Date Measure Calculation for Prior Non Working Dates

 

Hello Geeks,

 

Just trying another approach, so creating another thread as the scenario is different with just one table with next business date in it.

 

Expected Outcome - Products Received for a given order date and Order Received Date Business Day combo.

 

Sample 1 - For Order Date 10 Jan, Products received on Second Business Day that is 13 Jan should count for Products Received on 13 Jan (4) + Products Received on prior Holidays (20 (14 Jan( + 20 (15 Jan) ) = 44

 

 

Input   
    
Order dateOrder Received DateCurrent or Next Working DateProducts Received
10-Jan10-Jan10-Jan1
10-Jan11-Jan13-Jan20
10-Jan12-Jan13-Jan20
10-Jan13-Jan13-Jan4
10-Jan14-Jan15-Jan3
13-Jan13-Jan13-Jan9
13-Jan14-Jan15-Jan7
13-Jan15-Jan15-Jan9
15-Jan15-Jan15-Jan8
15-Jan16-Jan16-Jan9
15-Jan17-Jan17-Jan1
    
    
Expected Outcome  
    
Order dateProducts Received Same DayProducts Received Second Business Day
(Including holiday shipments)		Products Received Third Day
(Including holiday shipments)
10-Jan1443
13-Jan9160
15-Jan891
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi curiouspbix0 ,

     

    I'd like to suggest you add a calculated column group to your table, then create a matrix visual with order date as row, group as column and sum of product as value.

    Group = 
COUNTROWS (
    FILTER (
        SUMMARIZE ( ALL ( Table1 ), [Order date], [Current or Next Working Date] ),
        [Order date] = EARLIER ( Table1[Order date] )
            && [Current or Next Working Date] < EARLIER ( [Current or Next Working Date] )
    )
) + 1

     

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi curiouspbix0 ,

     

    I'd like to suggest you add a calculated column group to your table, then create a matrix visual with order date as row, group as column and sum of product as value.

    Group = 
COUNTROWS (
    FILTER (
        SUMMARIZE ( ALL ( Table1 ), [Order date], [Current or Next Working Date] ),
        [Order date] = EARLIER ( Table1[Order date] )
            && [Current or Next Working Date] < EARLIER ( [Current or Next Working Date] )
    )
) + 1

     

    Regards,

    Xiaoxin Sheng