Forum Discussion
Solved
How to get a value from another table based on the max date selected in a filter?
Hi everyone, I'm really new to Power BI and need some help. 🙂 Would you be able to help me write a DAX formula to get the YTD Plan based on the max date selected in a date filter? Ex: I have a d...
Sure, just change the aggregation:
Month YTD Goal (Measure) = VAR __MaxDate = MAX('Date'[Date]) RETURN SUMX(FILTER(ALL('Table 2'),'Table 2'[Date] = __MaxDate),'Table 2'[YTD Plan])
Greg_Deckler
Community Champion
Community ChampionSure, just change the aggregation:
Month YTD Goal (Measure) =
VAR __MaxDate = MAX('Date'[Date])
RETURN
SUMX(FILTER(ALL('Table 2'),'Table 2'[Date] = __MaxDate),'Table 2'[YTD Plan])
Greg_Deckler That worked! Yay! Thank you very much! 😃
I just need to remove the ALL after the FILTER. This is what I used:
Month YTD Goal (Measure) =
VAR __MaxDate = MAX('Date'[Date])
RETURN
SUMX(FILTER(('Table 2'),'Table 2'[Date] = __MaxDate),'Table 2'[YTD Plan])
- Greg_Deckler
Awesome! Glad we got there! 🙂