CalculateTable

[judddonnelly]

I am trying to generate an average for the last 20 days(offset and get no value.

CurA =
AverageX(
CALCULATETABLE(
'FACT_PROD_CUM_VW',
Filter('FACT_PROD_CUM_VW',FACT_PROD_CUM_VW[Prod Date] < [CurStart]) , Filter('FACT_PROD_CUM_VW',FACT_PROD_CUM_VW[Prod Date] > [CurEnd])
),
[Gross Oil]
)

CurStart = min(FACT_PROD_CUM_VW[currentstart])

currentstart = DATE(YEAR(FACT_PROD_CUM_VW[Prod Date]),MONTH(FACT_PROD_CUM_VW[Prod Date]),DAY(FACT_PROD_CUM_VW[Prod Date])) -2

CurEnd = min(FACT_PROD_CUM_VW[currentend])

currentend = DATE(YEAR(FACT_PROD_CUM_VW[Prod Date]),MONTH(FACT_PROD_CUM_VW[Prod Date]),DAY(FACT_PROD_CUM_VW[Prod Date])) -20

[V-lianl-msft]

Hi @judddonnelly ,

Unfortunately, I don't know your data model. Try to provide some sample data and the results you expect so that we can have a better understanding of your scenario.

How-to-provide-sample-data-in-the-Power-BI-Forum 

How-to-Get-Your-Question-Answered-Quickly 

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

[m3tr01d]

So Let say today's date is 2021 June 15. 
What would be the value for CurStart and CurEnd in your measure?

[judddonnelly]

It's not about Today....they will be 2 days before the value of prod_date and 22 days after prod_date respectively.