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.
This one is perplexing me.... Thought this would be easy... but no.
I have a situation where I have a tolerance that changes on an irregular frequency; such as...
What I need is a way of putting a target line on a line chart, or table that shows the target for that day, so in table below the 7% tolerance would apply on all dates 01 March 2020 through to 11 March 2020, then 12 March 2020 to 24 March 2020 would be 5% etc etc. Daily dates are in a Date Table called Calendar, and tables are joined Date to Date
I'd like to do this as a measure because Id want to use the daily tolerance in other measures and in graphs (eg do a line chartshowing daily performance vs tolerance for that day), I can do a calculated column in the calendar table if i have to, but would rather not.
Ive got this far, but it only returns a value on the specific day not the dates between...
Any advice appreciated...
Solved! Go to Solution.
Maybe:
Sum of Target Column in Date table =
VAR __TargetDate = MAXX(FILTER(ALL('ToleranceTarget'),'ToleranceTarget'[Date] <= 'Date'[Date]),'ToleranceTarget'[Date])
VAR __Target = MAXX(FILTER(ALL('ToleranceTarget'),'ToleranceTarget'[Date] = __TargetDate),[Target])
RETURN
__Target
Maybe:
Sum of Target Column in Date table =
VAR __TargetDate = MAXX(FILTER(ALL('ToleranceTarget'),'ToleranceTarget'[Date] <= 'Date'[Date]),'ToleranceTarget'[Date])
VAR __Target = MAXX(FILTER(ALL('ToleranceTarget'),'ToleranceTarget'[Date] = __TargetDate),[Target])
RETURN
__Target
Thanks Greg.... worked a treat.... id prefer a measure but a calculated column works... i have about 8 tolerances like this so it gets me going..
Thankyou again
Keep keep safe in these troubled times
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 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |