Calculate value based on percentage next year

[marsclone]

I believe a simple question, but i don't find it.

I want to calculate the value for the coming years with the help of the growth percentages in another table.

How do i do that?

Thank you in advance.

Test File 

[Anonymous]

Hi @marsclone,

Did these suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements to find them more quickly.

If these also don't help, please share more detailed information to help us clarify your scenario and test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[CNENFRNL · Accepted solution]

Unpivot growth ratio table in the first place,

[marsclone]

@CNENFRNL 

Thank you for this.

The values are calculated correctly, but i want this connected to a datetable.

Even when i have a date connected and put Year (Datetable) in the Matrix, values are not shown.

What goes wrong?

Thanks!

[Anonymous]

Hi @marsclone,

When you link date table to your fact table, it will enable an additional filter effect from the table relationship keys and may break the iteration calculation of cumulative expression.

For this scenario, you may need to add all functions to force ignore the filter effects from that specific table.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,

Xiaoxin Sheng

[amitchandak]

@marsclone , YTD for next year

Last Year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

2nd Last Year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

diff % = divide([Last Year Sales]-[2nd Last Year Sales],[2nd Last Year Sales])

next year sales = [Last Year Sales] *(1+[diff %])

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.