Help with Summarize for a virtual table

[Asingh31]

Hi @everyone,
I need some help/guidance regarding one statement in DAX.
Below is my DAX

Table =
ADDCOLUMNS(

                SUMMARIZE(

                            'F_Product availability',

                            'F_Product availability'[DATE_DAT],

                            'Calendar'[Date],

                            'Dim_Customer Products'[ID_COD],

                            Dim_Retailer[Retailer_1],

                            "SUM_OOS" , SUM('F_Product availability'[Is OOS])

                            ),

                            "Last available date1" ,

                            VAR CurrentDate = MAX('Calendar'[Date])

                            RETURN CALCULATE ( MAX ( 'F_Product availability'[DATE_DAT] ), 'F_Product availability'[AVAILABILITY_FLG] = "Y", Calendar[Date] <= CurrentDate ))

                            //"Total" , IF( INT([Last available date1] - [Date]) >= -90, [SUM_OOS],0))

 In the screen shot, you will find the desired output.

[amitchandak]

@Asingh31 , As this is column, do not use max

Table =
ADDCOLUMNS(
SUMMARIZE(
'F_Product availability',
'F_Product availability'[DATE_DAT],
'Calendar'[Date],
'Dim_Customer Products'[ID_COD],
Dim_Retailer[Retailer_1],
"SUM_OOS" , SUM('F_Product availability'[Is OOS])
),

"Last available date1" ,
VAR CurrentDate = ('Calendar'[Date])
RETURN CALCULATE ( MAX ( 'F_Product availability'[DATE_DAT] ), 'F_Product availability'[AVAILABILITY_FLG] = "Y", Calendar[Date] <= CurrentDate ))

or you can try earlier

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s