Max of a value

[Anonymous]

Hi All, 

Im trying to calculate the maximum date for the latest year data that I have. i.e for year 2020 Im trying to calculate the maximum month with the below dax query.

However, im getting the data in the below format where as I only require the maximum value i.e "5".

Later, when im trying to use this column as a in another column, im getting a circular dependency error. How can I resolve this?

[amitchandak · Accepted solution]

@Anonymous , You need to try like

calculate(Max(Table[Month]), Filter(allselected(Table), Table[Year] = max(Table[Year]) ) )

[Anonymous]

Thank you it worked 🙂