Forum Discussion
BGB
Helper II
4 years agoCurrent Month Day No Forecast
Hi All, I'm doing forecast figures for some projects and I have been asked that in the current month (in this case March 2022) when the date is below the 15th the forecast figure should be Previo...
- 4 years ago
How about now? Tomorrow it will be 485 😁
Measure = SWITCH ( TRUE(), AND ( SELECTEDVALUE('Date'[Month_no]) < MONTH(TODAY()), SELECTEDVALUE('Date'[Year]) <= YEAR(TODAY()) ), SUM('Budget Actual'[Actual Cost]), --Before Active Month AND ( SELECTEDVALUE('Date'[Month_no]) > MONTH(TODAY()), SELECTEDVALUE('Date'[Year]) >= YEAR(TODAY()) ), [Actual and forecast], --After Active Month TODAY () < DATE ( YEAR(TODAY()), MONTH(TODAY()), 15 ), [Actual and Forecast PM], -- Active Month, Before 15 SUM('Budget Actual'[Actual Cost]) -- Active Month, After 15 )
BGB
Helper II
4 years agocoskuersanli Thanks for looking at this.
When I tried this in a measure it won't accept 'Date'[date] and when I tried to use it as a column it didn't accept today
line 7..
coskuersanli
Resolver III
4 years agoCan you put () after TODAY and try again? 🙂