The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
I have a simple dax expression that grabs a value (weight) as per the earlierst date:
EarliestWeight =
CALCULATE(
SUM(SourceTable[Weight]),
FILTER(SourceTable,SourceTable[Date] = MIN(SourceTable[Date])))
I want to create another expression that ignores any filtering on the date slicer, so I get the abosulte minimum date no matter the date filters.
I can't seem to work it out. Help much appreciated.
EarliestWeight = VAR _minDate=MINX(ALL(SourceTable),SourceTable[Date]) RETURN
CALCULATE(
SUM(SourceTable[Weight]),
FILTER(SourceTable,SourceTable[Date] = _minDate))
Thanks, but for some reason it seems to only return a blank.
User | Count |
---|---|
13 | |
9 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |