Forum Discussion
Solved
Create a KPI target based on the previous year value
For example, if I have 10000 items sold in 2022, and if I want my target in 2023, I must do : 10000 * 1.8. I have: table1[items], table1[date] items date car 2022/06/19 table 2023/10/11 ...
Hi game1 ,
I updated the sample pbix file, please find the details in the attachment.
Target = VAR _year = SELECTEDVALUE('Date'[Date].[Year] ) VAR _month = SELECTEDVALUE('Date'[Date].[MonthNo],12) VAR _pycount = CALCULATE ( COUNT ( 'Table'[items] ), FILTER ( ALLSELECTED ( 'Table' ), YEAR ( 'Table'[date] ) = _year-1 && IF(ISFILTERED('Date'[Date].[Month]),MONTH ( 'Table'[date] ) = _month,1=1) ) ) RETURN _pycount * 1.8Best Regards
Hi game1 ,
I created a sample pbix file(see the attachment), please check if that is what you want.
Target =
VAR _year =
SELECTEDVALUE('Date'[Date].[Year] )
VAR _month =
SELECTEDVALUE('Date'[Date].[MonthNo],12)
VAR _pycount =
CALCULATE (
COUNT ( 'Table'[items] ),
FILTER (
ALLSELECTED ( 'Table' ),
YEAR ( 'Table'[date] ) = _year-1
&& MONTH ( 'Table'[date] ) <= _month
)
)
RETURN
_pycount * 1.8
Best Regards
Hello,
It is only working for Year, not for Month. For example, I should have for october 2023, 1.8 x 1 = 1.8, because it should count the items of october, for the previous year. In october 2022, we have 1 item. So, the target for ocotber 2023, must be : 1.8 x 1 = 1.8. It I select only Year, it work perfectly, but month is not giving the good result. Thanks!
Hi game1 ,
I updated the sample pbix file, please find the details in the attachment.
Target = VAR _year = SELECTEDVALUE('Date'[Date].[Year] ) VAR _month = SELECTEDVALUE('Date'[Date].[MonthNo],12) VAR _pycount = CALCULATE ( COUNT ( 'Table'[items] ), FILTER ( ALLSELECTED ( 'Table' ), YEAR ( 'Table'[date] ) = _year-1 && IF(ISFILTERED('Date'[Date].[Month]),MONTH ( 'Table'[date] ) = _month,1=1) ) ) RETURN _pycount * 1.8Best Regards
