Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey everone,
I have a requirement where I need to take the first value of the count column (not minimum or sum).
For e.g. I have dummy data below where the slicer is from 1/1/2020. I need to be able to take the first "From_Count" on the row when sorted by that specific date.
In this scenario the calculation would take the count 203 as that is the first value of the table sorted by the date.
Can anyone help?
I tried creating
CALCULATE(sum(CRCT_METER_CNT[From_Count]), FILTER(CV_BW_DIM_DATE,CV_BW_DIM_DATE[DATE] = [FROM_DATE_FROM_SLICER]))
however the measure is giving me a value of 2466 and not 203.
Solved! Go to Solution.
@Anonymous
Not sure of the calculation [FROM_DATE_FROM_SLICER]. You can use min or max or slicer date and create a formula like
Measure =
var _max = maxx(Date,Date[Date])// [FROM_DATE_FROM_SLICER], use min or mex
CALCULATE(sum(CRCT_METER_CNT[From_Count]), FILTER(CV_BW_DIM_DATE,CV_BW_DIM_DATE[DATE] =_max ))
@Anonymous
Not sure of the calculation [FROM_DATE_FROM_SLICER]. You can use min or max or slicer date and create a formula like
Measure =
var _max = maxx(Date,Date[Date])// [FROM_DATE_FROM_SLICER], use min or mex
CALCULATE(sum(CRCT_METER_CNT[From_Count]), FILTER(CV_BW_DIM_DATE,CV_BW_DIM_DATE[DATE] =_max ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |