Help with simple CALCULATE meassure

[Anonymous]

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 Quarter available (with 13 or more weeks)

En error shows up saying: "the true/false expression does not specify a column"

How can I fix it? Thanks!

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

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.

[amitchandak]

@Anonymous , if you are using a date table(Of have date, then join with date table) , then you can get like

Last QTD Sales = CALCULATE(Max('Date'[Qtr]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))