cancel
Showing results for
Did you mean:
Member

## Assign a specific value of a measure to other date

hi,

I have a Demand table and define a measure to cumulate the demand.

How can I write a measure that assigns the demand of a specific date to other dates: Eg.  demand = 12/14/2018 is 21, and I want all date from 12/15/2018 showing this value of 21:

```Date	  Demand  Cumm' Demand	**bleep**' of 12/14/2018
12/9/2018	1	1
12/10/2018	2	3
12/11/2018	3	6
12/12/2018	4	10
12/13/2018	5	15
12/14/2018	6	21
12/15/2018	7	28	21
12/16/2018	8	36	21
12/17/2018	9	45	21
12/18/2018	10	55	21
12/19/2018	11	66	21
12/20/2018	12	78	21
12/21/2018	13	91	21
12/22/2018	14	105	21
12/23/2018	15	120	21
12/24/2018	16	136	21
12/25/2018	17	153	21
12/26/2018	18	171	21
12/27/2018	19	190	21
12/28/2018	20	210	21
12/29/2018	21	231	21
12/30/2018	22	253	21
12/31/2018	23	276	21```

Link Excel is below:

https://1drv.ms/x/s!Aps8poidQa5zk5VU3j6goEzW7AXYdg

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Assign a specific value of a measure to other date

Thanks for your trying, but it doesn't give me the desired result.

I found a simple solution by using IF( date > 12/14/2018, calculate(**bleep** sum,  date = 12/14/2018, blank())

6 REPLIES 6
Super User

## Re: Assign a specific value of a measure to other date

Hi @Iamnvt

is the table you're showing the 'raw' table? are you looking to do this via a calculated column or with a measure?

Did I answer your question correctly? Mark my answer as a solution!

Proud to be a Datanaut!

Member

## Re: Assign a specific value of a measure to other date

the table is raw data  --> with the last column is the desired result. I want to have a MEASURE to calculate that. This will be applied to a bigger model.

Thanks

Super User

## Re: Assign a specific value of a measure to other date

Hi @Iamnvt

is the cumulation done at the month level or it is an overall cumulation?  how will you chsoose the date on which to stop, in a slicer?

Did I answer your question correctly? Mark my answer as a solution!

Proud to be a Datanaut!

Member

## Re: Assign a specific value of a measure to other date

It is overall cumulation. Date in slicer is between a range.
I just want the value of 14/12/2018 (21) to be appeared in all selected date after a defined date (eg.15/12/2018)
Super User

## Re: Assign a specific value of a measure to other date

Hi @Iamnvt

try this measure after having created a calendar table connected to your original table:

```Measure =
CALCULATE(
SUM( 'Table'[Demand] ),
FILTER(
ALL( 'Calendar'[Date] ),
'calendar'[Date] <= MIN( MAX( 'Calendar'[Date] ), DATE( 2018, 12, 14 ) )
)
)```

Did I answer your question correctly? Mark my answer as a solution!

Proud to be a Datanaut!

Member

## Re: Assign a specific value of a measure to other date

Thanks for your trying, but it doesn't give me the desired result.

I found a simple solution by using IF( date > 12/14/2018, calculate(**bleep** sum,  date = 12/14/2018, blank())