Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a date slicer on one page and also a card. The card is numerical data in columnar form which has a date (single day) associate with each day.
With the slicer in a range, it only gives me the options to "sum, average, minimum, etc. etc.".
What I want is the LAST value, so only the value for the end range of the slicer. Not sure how to accomplish this.
Thanks!
Solved! Go to Solution.
Hi @DataGeo
Is this calculated measure what you mean? My table is called Table, and the two columns are [Date] and [Value]
Measure = VAR d = LASTDATE('Table'[Date]) RETURN SUMX( FILTER( 'Table', 'Table'[Date]=d), 'Table'[Value])
Hi @DataGeo
Is this calculated measure what you mean? My table is called Table, and the two columns are [Date] and [Value]
Measure = VAR d = LASTDATE('Table'[Date]) RETURN SUMX( FILTER( 'Table', 'Table'[Date]=d), 'Table'[Value])
Hi, It works fine if you use the Date column in the same Table, but I'm using a Date hierarchy that is in a Calendar Table and it doesnt work. Can anybody helpme?
Nailed it! Thank you!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |