Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have 2 tables
Ddate
Date | Month | Month Year |
4/1/2024 | 4 | April 2024 |
3/1/2024 | 3 | Mar 2024 |
4/28/2024 | 4 | April 2024 |
3/3/2024 | 3 | Mar 2024 |
4/27/2024 | 4 | April 2024 |
4/29/2024 | 4 | April 2024 |
4/30/2024 | 4 | April 2024 |
Revenue
Value | Record Date | Customer |
30 | 3/1/2024 | A |
100 | 3/1/2024 | C |
200 | 4/27/2024 | A |
30 | 4/28/2024 | A |
60 | 4/27/2024 | C |
80 | 4/27/2024 | B |
40 | 4/28/2024 | B |
50 | 3/1/2024 | B |
90 | 4/28/2024 | C |
They are both connected by Date-Record date
I want to create a measure for revenue value at the maximum date in Revenue table, ignoring the Monthyear filter
For example, if i selected Mar 2024, and customer C, I want to show the revenue on the max date (04/28/2024), which is 90.
when i used
Thank you in advance!
Solved! Go to Solution.
@Shinyl Try:
Measure =
VAR __MaxDate = MAXX(ALL(Revenue[RecordDate]),Revenue[RecordDate]))
VAR __Result = SUMX( FILTER( ALLEXCEPT('Revenue', [Customer]), [RecordDate] = __MaxDate ), [Value] )
RETURN
__Result
Hi,
PBI file attached.
Hope this helps.
@Shinyl Try:
Measure =
VAR __MaxDate = MAXX(ALL(Revenue[RecordDate]),Revenue[RecordDate]))
VAR __Result = SUMX( FILTER( ALLEXCEPT('Revenue', [Customer]), [RecordDate] = __MaxDate ), [Value] )
RETURN
__Result
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
110 | |
109 | |
94 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |