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.
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!
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 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |