Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a dashboard with Table visualization and has a date filter. I want to create a calcutate measure based on the end date of the date slicer.
So, if my date range in date slicer is from 7/25/2019 to 8/19/2019, then the measure should only take value from 8/19/2019. Further more, I have a measure already and would like to incorporate it in the measure if possible. The measure is as follows:
Solved! Go to Solution.
Hello @rschaudhr
Give this a try.
Measure = VAR _LastDate = LASTDATE ( Dates[Date] ) RETURN CALCULATE ( DIVIDE ( SUM ( [EOP MV] ), CALCULATE ( SUM ( [EOP MV] ), ALLEXCEPT ( IPA, Date, [Manager] ) ) ), _LastDate )
Actually, I am misspoken. Your solution did work. Thank you for this.
Hello @rschaudhr
Give this a try.
Measure = VAR _LastDate = LASTDATE ( Dates[Date] ) RETURN CALCULATE ( DIVIDE ( SUM ( [EOP MV] ), CALCULATE ( SUM ( [EOP MV] ), ALLEXCEPT ( IPA, Date, [Manager] ) ) ), _LastDate )
Unfortunately, this did not work
You will have to give a bit more information. Did you receive an error or an unexpected result? Can you share some of your sample data in a format that can be copied (not a screen shot) and show us how your model is layed out and what the expected result is?
Actually, I am misspoken. Your solution did work. Thank you for this.
Here is a post about creating the measure that references a date range slicer
https://community.powerbi.com/t5/Desktop/Filter-data-using-date-range-from-slicer/td-p/483072
Help when you know. Ask when you don't!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |