The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |