Sum sales of last working days

[powerbi2srm]

I want to calculate sales of last three WORKING days. I have a boolean column in table dates (is_not_working_day) which it checks "TRUE" when it isn't working day. 

In addition, I have created a table that returns the record of the last time the report was updated.

I want it to return me the sum of the sales (SUM(sale_order[sales_amount])) of the last 3 WORKING days. For example if today is Friday and Thursday was NOT a business day, I should sum the sales for Wednesday, Tuesday, and Monday.

Thank you so much!!!

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

last 3 working days sales: =
VAR _currentrowdate =
    MAX ( 'Calendar'[Date] )
VAR _t =
    FILTER (
        ALL ( 'Calendar' ),
        'Calendar'[is_not_working_day] = FALSE ()
            && 'Calendar'[Date] < _currentrowdate
    )
RETURN
    CALCULATE (
        SUM ( Sales[Sales] ),
        WINDOW ( 1, ABS, 3, ABS, _t, ORDERBY ( 'Calendar'[Date], DESC ) )
    )

[powerbi2srm]

Please, anyone can help me? @amitchandak @Greg_Deckler  @lbendlin @Ashish_Mathur @Ahmedx  @ryan_mayu @jdbuchanan71 @Jihwan_Kim Thank you so much!