Forum Discussion

lallac's avatar
lallac
Frequent Visitor
2 years ago

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(A...
Need Help
AnalyticPulse's avatar
AnalyticPulse
Solution Sage
2 years ago

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

Powerbi Visualisation

 

 

 

lallac's avatar
lallac
Frequent Visitor
2 years ago

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?