cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
LivioLanzo Super Contributor
Super Contributor

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

LivioLanzo Super Contributor
Super Contributor

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)
LivioLanzo Super Contributor
Super Contributor

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

 

 

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 142 members 1,620 guests
Please welcome our newest community members: