Solved: OFFSET() Measure compatible with a SSAS Live Conne...

Anonymous · ‎12-22-2023

Title says it all, cannot get OFFSET to work with my Live Connection to SSAS with the Dec 2023 version of PBI.

Thanks,
Aaron

TomMartens · ‎12-22-2023

Hey @Anonymous ,

I'm sure the DAX Windowing functions like OFFSET are only supported with SQL Server Analysis Services Tabular 2022.

If "Live Connection" means a prior on-premises version of SSAS Tabular, than it will not work.

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

TomMartens · ‎12-22-2023

Hey @Anonymous ,

I'm sure the DAX Windowing functions like OFFSET are only supported with SQL Server Analysis Services Tabular 2022.

If "Live Connection" means a prior on-premises version of SSAS Tabular, than it will not work.

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Anonymous · ‎01-02-2024

Hi Tom, It is indeed an older version of SSAS and not 2022 I am using.

Thanks.

OFFSET() Measure compatible with a SSAS Live Connection (Dec 2023 PBI Desktop)