Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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] < [...
Need Help
m3tr01d's avatar
m3tr01d
Continued Contributor
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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