Forum Discussion

Post Patron

9 years ago

Dynamic Last 7 day

I am trying to calculate the sales for the last 7 days, but the last 7 days will be dynamic, based on the date selected in a slicer. eg. if the date selected in the slicer is 2017/07/18, then the...

Need Help

Show and Tell

TomMartens

Super User

9 years ago

Hey,

VAR is not supported in SQL Server 2014 as stated here:

https://msdn.microsoft.com/en-us/library/mt243785.aspx

and also have a look here:

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016

Regards

Rameshwar

Frequent Visitor

9 years ago

Thanks TomMartens. I was hoping the same.

Thanks,

Rameshwar

Forum Discussion

Dynamic Last 7 day

Related content

# of Days Dynamic

Data Days | Data Days Your Way

Day to Day average

Dynamic Filter

Dynamic parameter selection for due days