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.
Hello,
I've been trying, unsuccessfully, to calculate a measure summing up values between two dates. The lower limit date is MIN(Calendar[Date]) while the upper limit should be a dynamic selection from a Date Slicer.
The last two items I've tried are:
MNQ EndBalance = CALCULATE(SUM(Quantities[Value]),DATESBETWEEN('Calendar'[Date],
MIN('Calendar'[Date]),CALCULATE(MIN(Calendar[Date]),ALLSELECTED(Calendar[Date]))))
MNQ EndBalance = CALCULATE(SUM(Quantities[Value]),DATESBETWEEN('Calendar'[Date],
MIN('Calendar'[Date]),SELECTEDVALUE(Calendar[Date]))).
Link to sample file here: BetweenDatesSampleFile
Any suggestions would be highly appreciated.
Thank you.
Solved! Go to Solution.
Try this measure:
MNQ EndBalance =
VAR vStartDate =
MINX ( ALL ( 'Calendar' ), 'Calendar'[Date] )
VAR vEndDate =
MAXX ( ALLSELECTED ( 'Calendar' ), 'Calendar'[Date] )
VAR vResult =
CALCULATE (
SUM ( Quantities[Value] ),
DATESBETWEEN ( 'Calendar'[Date], vStartDate, vEndDate )
)
RETURN
vResult
Proud to be a Super User!
Try this measure:
MNQ EndBalance =
VAR vStartDate =
MINX ( ALL ( 'Calendar' ), 'Calendar'[Date] )
VAR vEndDate =
MAXX ( ALLSELECTED ( 'Calendar' ), 'Calendar'[Date] )
VAR vResult =
CALCULATE (
SUM ( Quantities[Value] ),
DATESBETWEEN ( 'Calendar'[Date], vStartDate, vEndDate )
)
RETURN
vResult
Proud to be a Super User!
User | Count |
---|---|
86 | |
84 | |
35 | |
35 | |
35 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |