Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

formula placement

Hi,

trying to figure out how to best model this formula.

 

I have a simple sales table (however my actual data is very large, but for this example i'm using simple columns).

 

Order NumberShip datepromise datesales $
20002/10/20202/13/20205
20012/10/20202/10/202010
20022/11/20201/25/20205
20032/11/20202/15/202010
20042/12/20202/11/20205
20052/12/20202/12/202010
20062/13/20202/1/202015
20072/13/20202/13/202020
20082/14/20202/1/202025
20092/14/20203/1/202025
20092/14/20202/10/202030

 

The formual we set up in excel is for on time delivery between promise and actual dates. 

 

My instinct says to add columns and create formulas similar to how i have in my excel file for days late and OTD flag (see below).

 

Order NumberShip datepromise datesales $Workdays lateOTD Flag
20002/10/20202/13/20205              3On Time
20012/10/20202/10/202010             -  On Time
20022/11/20201/25/20205          (13)over 5 days late
20032/11/20202/15/202010              3On Time
20042/12/20202/11/20205            (3)1 to 5 days late
20052/12/20202/12/202010             -  On Time
20062/13/20202/1/202015          (10)over 5 days late
20072/13/20202/13/202020             -  On Time
20082/14/20202/1/202025          (11)over 5 days late
20092/14/20203/1/202025            10On Time
20092/14/20202/10/202030            (6)over 5 days late

 

Knowing that i'm not very fluent in PBI, i was wondering if there is another way to either quicken the process time for the user or enhance visuals to do it another way.  I am still not sure how the "new table" in modeling works. 

 

Thanks for the feedback.

 

 

Need Help

5 Replies