Forum Discussion

Asingh31's avatar
Asingh31
Frequent Visitor
3 years ago

Help with Summarize for a virtual table

Hi @everyone, I need some help/guidance regarding one statement in DAX. Below is my DAX Table = ADDCOLUMNS(                 SUMMARIZE(                             'F_Product availability',...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
3 years ago

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