Reply
Regular Visitor
Posts: 25
Registered: ‎02-17-2017
Accepted Solution

July amount - Repeting in to the future

I want to make a measure that take the july sale and repeat it in to the future. I thougt it should be an easy case but I cant manage.

 

Her is my measure:

CALCULATE([Totalsalg - Juli];filter(factData;factData[Dato]>=date(2018;7;1)))

 

Her is how I dont want it and want it:

Dax- Problem.png


Accepted Solutions
Super User
Posts: 3,737
Registered: ‎01-14-2017

Re: July amount - Repeting in to the future

Hi,

 

Here is the result i got.  You may downlod my PBI file from here.

 

Hope this helps.

 

Untitled.png

View solution in original post


All Replies
Community Support Team
Posts: 7,219
Registered: ‎08-14-2016

Re: July amount - Repeting in to the future

Hi @nankerp,

 

I'm not so sure how measure 'total slag juli' calculated, please share sample data with measure formula to test.

BTW, nested measure not works properly if internal measure contains filters.

 

Reference links:

Order of Evaluation in CALCULATE Parameters

Optimizing DAX expressions involving multiple measures

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Regular Visitor
Posts: 25
Registered: ‎02-17-2017

Re: July amount - Repeting in to the future

Her is the sourcedata.Dax2 problem.png

Super User
Posts: 3,737
Registered: ‎01-14-2017

Re: July amount - Repeting in to the future

Hi,

 

Here is the result i got.  You may downlod my PBI file from here.

 

Hope this helps.

 

Untitled.png

Highlighted
Regular Visitor
Posts: 25
Registered: ‎02-17-2017

Re: July amount - Repeting in to the future

Thank you so much. It was more complicated than I thought it should be.

Super User
Posts: 3,737
Registered: ‎01-14-2017

Re: July amount - Repeting in to the future

You are welcome.