MDX Filter data set on Current Year

Géraldine 0 Reputation points
2023-08-24T19:35:18.0066667+00:00

Hi there,

I’m a very beginner with MDX scripting.

I try to find a way to filter a dataset on the current year, in a MDX query.

My query is working well when I use à constant such as « 2023 », but no data are returned if I use à variable such [Measures].[Current Year] (as Year(Now())).

Can you help going through this ?

Thx ! G.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,441 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,243 questions
{count} votes