Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with simple CALCULATE meassure

Hello, I have the following meassure but it doesn't work   CALCULATE(MAX('DB'[Quarter]),'DB'[Year]=max('DB'[Year]),COUNTROWS(VALUES('DB'[Week]))>=13)   Im trying to return the last complete Quar...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Please try:

=CALCULATE(MAX('DB'[Quarter]),FILTER('DB'[Year]=max('DB'[Year])&&COUNTROWS(VALUES('DB'[Week]))>=13))

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.