Help with Summarize for a virtual table

Question

Hi&nbsp;@everyone,I need some help/guidance regarding one statement in DAX.Below is my DAXTable =ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'F_Product availability',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'F_Product availability'[DATE_DAT],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar'[Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Dim_Customer Products'[ID_COD],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim_Retailer[Retailer_1],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "SUM_OOS" , SUM('F_Product availability'[Is OOS])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Last available date1" , &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR CurrentDate = MAX('Calendar'[Date])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN CALCULATE ( MAX ( 'F_Product availability'[DATE_DAT] ), 'F_Product availability'[AVAILABILITY_FLG] = "Y", Calendar[Date] &lt;= CurrentDate ))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //"Total" , IF( INT([Last available date1] - [Date]) &gt;= -90, [SUM_OOS],0))&nbsp;In the screen shot, you will find the desired output.

amitchandak · Answer

Asingh31 , As this is column, do not use max
&nbsp;
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] &lt;= CurrentDate ))
&nbsp;
or you can try earlier
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8https://www.youtube.com/watch?v=cN8AO3_vmlY&amp;t=17820s

Forum Discussion

Help with Summarize for a virtual table

1 Reply

Related content

Fabric virtual table

Summarize virtual table

How to summarize virtual table table

Dynamic virtual summarized table

Merge Summarize Table