Forum Discussion
adding a FILTER function, using an inclusive range in a subselect
You just need to use STRTOMEMBER() with Now() function to get the date member for today, then apply the date range as subselect in your MDX.
I have replied the thread you posted on MSDN forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/45f744ff-6400-45fc-bbce-93a8c0f9e8f7/adding-a-filter-function-using-an-inclusive-range-in-a-subselect?forum=sqlanalysisservices
Regards,
You just need to use STRTOMEMBER() with Now() function to get the date member for today, then apply the date range as subselect in your MDX.
I have replied the thread you posted on MSDN forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/45f744ff-6400-45fc-bbce-93a8c0f9e8f7/adding-a-filter-function-using-an-inclusive-range-in-a-subselect?forum=sqlanalysisservices
Regards,