cancel
Showing results for
Did you mean:
Highlighted

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

after testing it out, i ended up figuring out the month.

thanks for the great solution.. i used the following:

`EOMONTH ( 'Table'[Last date in dataset], 'Table'[Value that represents the month] )`

-------------------------------------------------------------------------------------------------------------------------------------------

however, i need the "value" to change.. basically, what i'm getting is below... which means the "Value" column is just constant, while i need it to become continuously smaller.

 Type Name Date Value 1 a 2/28/2018 Last known Value (for "Name" a) * 0.77^(1/12) 1 a 3/31/2018 Last known Value (for "Name" a) * 0.77^(1/12) 1 a 4/30/2018 Last known Value (for "Name" a) * 0.77^(1/12) 1 a 5/31/2018 Last known Value (for "Name" a) * 0.77^(1/12) 1 a 6/30/2018 Last known Value (for "Name" a) * 0.77^(1/12) 1 a 7/31/2018 Last known Value (for "Name" a) * 0.77^(1/12) … … … Last known Value (for "Name" a) * 0.77^(1/12) 2 b 2/1/2018 Last known Value (for "Name" b) * 0.77^(1/12) 2 b 3/31/2018 Last known Value (for "Name" b) * 0.77^(1/12) … … … Last known Value (for "Name" b) * 0.77^(1/12) 2 b 1/31/2020 Last known Value (for "Name" b) * 0.77^(1/12)

what i need is

 Type Name Date Value 1 a 2/28/2018 Last known Value (for "Name" a) * 0.77^(1/12) 1 a 3/31/2018 Value predicted above * 0.77^(1/12) 1 a 4/30/2018 Value predicted above * 0.77^(1/12) 1 a 5/31/2018 Value predicted above * 0.77^(1/12) 1 a 6/30/2018 Value predicted above * 0.77^(1/12) 1 a 7/31/2018 Value predicted above * 0.77^(1/12) … … … … 2 b 2/1/2018 Last known Value (for "Name" b) * 0.77^(1/12) 2 b 3/31/2018 Value predicted above * 0.77^(1/12) … … … … 2 b 1/31/2020 Value predicted above * 0.77^(1/12)
Highlighted
Super User IV

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

Hi @aar0n,

I am not sure whom you are replying to.  Do you need any help from me?  Did my solution work?

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

hi ashish,

thank you for the contribution, but your solution has the same issue as the other solution, as shown by my example above.. the 'value' should be constantly decreasing towards 0, but in both solutions here, the values are a constant value for each date

Highlighted
Super User IV

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

Hi,

When you click on Data icon on the left hand side pane, you will observe that the Dates increment daywise.  is that correct or should they be incrementing month wise?

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

i see the dates increment daywise. the main issue though, is that the values are not calculating correctly..

@Zubair_Muhammad already fixed the increment by month issue, the only issue is that the "value" is constant

Highlighted
Super User III

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

@aar0n

To get the decreasing values, please add this calculated column to the calculated table you created

```My VALUE =
'Table'[Last Known Value ]
* ( 0.77
^ ( 1 / 12 ) )
^ 'Table'[Value that represents the month]```
Try my new Power BI game Cross the River
Highlighted

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

@Zubair_Muhammad that will not give me the correct value, since the calculation is being taken to the exponent of the month number.

it is really close, but below is a sample of what is happening, and what i'm looking for..

 Type Date Last known Value * (0.77^(1/12))^Value that represents month Last known Value * (0.77^(1/12)) Last known value 1/31/2017 29.69 29.69 calculated 2/28/2018 28.4243127 29.05033142 calculated 3/31/2018 27.81191325 28.42444444 calculated 4/30/2018 27.21270789 27.81204215 calculated 5/31/2018 26.62641236 27.21283401 calculated 6/30/2018 26.05274852 26.62653577 calculated 7/31/2018 25.49144422 26.05286927 calculated 8/31/2018 24.94223317 25.49156236 calculated 9/30/2018 24.40485483 24.94234877 calculated 10/31/2018 23.87905426 24.40496794 calculated 11/30/2018 23.36458202 23.87916493 calculated 12/31/2018 22.86119405 23.36469031 calculated 1/31/2019 22.36865152 22.8613 calculated 2/28/2019 21.88672078 22.36875519
Highlighted
Super User III

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

@aar0n

I will look into it

Try my new Power BI game Cross the River
Highlighted
Super User III

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

HI
&nbsp;
From your last post I noticed this. So I think adjusting the POWER by -1 should fix it.
&nbsp;
My VALUE =
'Table'[Last Known Value ]
* ( 0.77
^ ( 1 / 12 ) )
^ ('Table'[Value that represents the month]-1)
&nbsp;
Try my new Power BI game Cross the River
Highlighted

## Re: How to create a Calculated Table for Future Values in from a Unique Name list

Thank you!!!

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors