cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Krabbe Visitor
Visitor

Dynamic rolling chart

I have a chart, where I would like to show the previous 16 weeks. It seems the dates/calendar table is not registrered as a number value, rather than dates, so the relative date filter is not an option.

Can anyone help me fix this? I'm working in a SSAS live connection, so I feel like my options are limited. 

1 REPLY 1
Community Support Team
Community Support Team

Re: Dynamic rolling chart

HI, @Krabbe 

You may try this way like below:

For you are working in a SSAS live connection, all the modeling process need to be done in ssas, so you need to add a week

column for date field.

Then create a measure in power bi like this:

Measure = VAR __LASTWEEK = MAX(Table2[Week])
	RETURN
		SUMX(
			FILTER(ALL(Table2),Table2[Week]<=__LASTWEEK&&Table2[Week]>=__LASTWEEK-3),
			CALCULATE(SUM('Table2'[Qty]))
		)

For example:

8.JPG

 

 

Best Regards,

Lin

 

 

 

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