Forum Discussion
Tobias106
Helper I
4 years agoShow calculated value only in the corresponding year
Hello together, I have a "Table" which is linked to the "Calendar". The "Table" contains the years 2020 - 2023. What I want to do is to calculate the Revenue for 2020 in a Measure. This w...
- 4 years ago
maybe you can try this
Measure = if(year(max('calendar'[Date]))=2020,CALCULATE(sum('Table'[value]),FILTER(all('Table'),year('Table'[date])=2020)))pls see the attachment below