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.
Consider the below table
id | date | budget |
101 | 01/06/2020 | 50 |
101 | 01/07/2020 | 100 |
103 | 01/06/2020 | 50 |
103 | 01/07/2020 | 50 |
103 | 01/08/2020 | 20 |
I'm looking to create a measures
Desired output is a table as below
last date | budget | |
101 | 01/07/2020 | 100 |
103 | 01/08/2020 | 20 |
Thank you in advance
Solved! Go to Solution.
Hi @giordafrancis ,
You can use this for Last Date
Last Date = CALCULATE(LASTNONBLANK('Table'[date],1) ,FILTER(ALL('Table'[id]), 'Table'[id] = MAX('Table'[id])))
and the above mentioned measure for Last Budget.
Last Budget =
lastnonblankvalue('Table'[date],sum('Table'[budget]))
Regards,
Harsh Nathani
Hi @giordafrancis ,
You can use this for Last Date
Last Date = CALCULATE(LASTNONBLANK('Table'[date],1) ,FILTER(ALL('Table'[id]), 'Table'[id] = MAX('Table'[id])))
and the above mentioned measure for Last Budget.
Last Budget =
lastnonblankvalue('Table'[date],sum('Table'[budget]))
Regards,
Harsh Nathani
@giordafrancis , use this for budget
lastnonblankvalue(Table[date],max(Table[budget]))
or
lastnonblankvalue(Table[date],sum(Table[budget]))
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |