Forum Discussion
Getting the max month selected not working properly
Hello everyone,
I need a formula that returns the maximum month among the selected ones.
In my file, I have data up until April. I tried using
MAX(ANAG Months [Months])
and
MAXX(ALLSELECTED(ANAG Months [Months]), ANAG Months [Months])
but they all give me back "March", even when I select April or May.
I don't understand what I'm doing wrong. I would appreciate your help!
2 Replies
hi lallac
did you check this relationships?
if the relationships are correct there might be some filter that is preventinfg other month from appearing .
also check your backend data if its there for other months apart from march.Learn Power BI free:
https://analyticpulse.blogspot.com
Hi AnalyticPulse , thank you for replying.
There is a relationship between the database that I'm using and the month column, specifically between the column DB [Months] and ANAG Months [Months].
This relationship is working properly, in fact if I select a month from ANAG Month [Month], I can see the data of the month I selected. There are no other filters that block this from working.
I tried to upload the ANAG Month sheet on its own, but the formulas are still giving me the wrong month. If I select the months "March" and "June", it gives me back "March". Could it be a problem with the way that Power BI reads months when they're written in text?
