Getting the max month selected not working properly

[lallac]

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!

[AnalyticPulse]

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

Learn Power BI free

Commercial Real Estate Portfolio Overview by DataFreedom

Superstore Sales 2022 vs 2023: Year-on-Year Performance Comparison dashboard

Case Study: PowerBI Dashboard Developer for Sales Visualization

Case Study: Banking and Finance dashboard (Step by step guide)

Powerbi Visualisation

[lallac]

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?