Forum Discussion
CalculateTable
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
3 Replies
So Let say today's date is 2021 June 15.
What would be the value for CurStart and CurEnd in your measure?Hi Anonymous ,
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.
