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.
Hello!!!
I want to get the latest target based on the latest date and for the date format has time also, so basically the latest value based on max date and time.
The expeted output of this is 95, i have used max date funcation but it does not seem to work.
Project Name | Modified Date | Target |
BASIC | 13-Dec-22 14:00 | 95 |
BASIC | 13-Dec-22 13:00 | 90 |
BASIC | 13-Dec-22 12:00 | 85 |
Any suggest, how to get this working? Thanks a lot in advance!!
Solved! Go to Solution.
hi @JCK2
try to plot a visual table with a measure of this:
the dataset:
Thanks everyone! let me try them 🙂
hi @JCK2
try to plot a visual table with a measure of this:
the dataset:
it can be further simplified like this:
Hi @JCK2 ,
Something like this:
//get max date for 1 project
VAR MaxDate = calculate( max('table'[Modified Date]), allexcept('table, 'table'[project name]))
RETURN
//get target for max date for the project. Instead of max, you can use min as you retrieve only 1 value
//assumpton: you have a relationship between table date & project date
calculate( max('table'[Target]), datetable[date] = MaxDate)
_TargetMaxDate =
VAR __filer = MAX('Table'[Modified Date])
VAR __target = CALCULATE(SELECTEDVALUE('Table'[Target]), 'Table'[Modified Date] = __filer)
RETURN
__target
Hello @JCK2 ,
If you only want the target create this measure to give you the last value of target:
If you also want the latest date associated create an other measure like this
Hope it helps 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 |
---|---|
44 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |