Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi @everyone,
I need some help/guidance regarding one statement in DAX.
Below is my DAX
In the screen shot, you will find the desired output.
@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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
98 | |
96 | |
59 | |
44 | |
40 |