cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Iamnvt Member
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
Iamnvt Member
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
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!  

Iamnvt Member
Member

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

@LivioLanzo 

 

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
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!  

Iamnvt Member
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
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!  

Iamnvt Member
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())