Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
57 | |
50 | |
36 | |
34 |
User | Count |
---|---|
84 | |
74 | |
56 | |
45 | |
44 |