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 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!
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |