Time Intelligence using SSAS Live Connection

[Anonymous]

Hi all,

Tried reading the official MS documentation but that did not enlighten me very much.

Im having issues getting some basic DAX time intelligence functions to work in my report. That said, this is my first time using an SSAS Tabular model w/ Live connection as a source, so I suspect this has something to do with the issues.

I have a separate date dimension, and I want to create a parallel period/last year etc. measure using the following code:

same period last month = CALCULATE(SUM('FactTable'[sales_total_amount]);PARALLELPERIOD('DateTable'[date_key];-1,MONTH))

Using this, or ANY other time intelligence (such as trying DATEADD), I get an error under MONTH in this instance saying the syntax is incorrect. 

Has anyone experienced anything similar or perhaps anyone who knows what the issue is here?

[v-juanli-msft]

Hi @Anonymous

According to this case, Please put “;Month” instead of “,Month”.

Or use the following instead which I test with successfully

same period last month = CALCULATE(SUM('FactTable'[sales_total_amount]),PARALLELPERIOD('DateTable'[date_key],-1,MONTH))

Best Regards

Maggie

[Anonymous]

Thanks for correcting that misspelling, @v-juanli-msft! 

I am still having issues, since the DAX calculation won't work properly. When I try to calculate MoM change and use it in a waterfall chart or bar chart, it won't show any values unless I go down to the per-day level which is useless in this case. I wish to show it per month. When trying to show it per month, it's completely blank.

Now, I have tried several different ways of calculating the month-over-month change. This is my latest attempt:

Revenue MoM% = 
IF(
	ISFILTERED(v_d_date[date_key]);
	VAR __PREV_MONTH =
		CALCULATE(
			SUM(v_pact_f_charge_record[sales_total_amount]);
			DATEADD(v_d_date[date_key]; -1; MONTH)
		)
	RETURN
		DIVIDE(SUM(v_pact_f_charge_record[sales_total_amount]) - __PREV_MONTH; __PREV_MONTH)
)

I have also tried the PREVIOUSMONTH to create a Last Month measure and so on. Nothing works. The same goes for Year over year change as well.

But here comes the weird part: Currently, I have a ribbon chart that actually manages to show - via tooltip (sales_total_amount Change) - the calculation that I want to create. I have no idea how it somehow works in the ribbon chart, but won't work when I write my own dax measure. Anyone? Beginning to get desperate over here!