Forum Discussion

vanessa's avatar
vanessa
Icon for Post Patron rankPost 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
Rameshwar's avatar
Rameshwar
Frequent Visitor
9 years ago

Hi Anonymous

 

Your formula works correctly in PowerBI Desktop when I have In Memory data. 

 

However, its not working when I've PowerBI Desktop conected to SSAS Tabular instance (1103 compatibility - SQL2014) with Direct Query connection. It gives me syntax error for VAR function.

 

Is VAR function not supported in SSAS, specifically to 1103 compatibility level?

 

Thanks for your help!

 

Thanks,

Rameshwar 

 

  • Rameshwar's avatar
    Rameshwar
    Frequent Visitor
    9 years ago

    Thanks TomMartens. I was hoping the same. 

     

    Thanks,

    Rameshwar