Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
here is my current code and im very new to MDX and playing ard.
SELECT NON EMPTY { [Measures].[Affiliations Count], [Measures].[Practitioners Count] } ON COLUMNS,
NON EMPTY { ([Associations].[Network].[Network].ALLMEMBERS * [Associations].[Health Plan].[Health Plan].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( STRTOSET("[All]", CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( { [Associations].[Record Type].&[Practitioner] } ) ON COLUMNS
FROM ( SELECT ( -{ [Associations].[Health Plan].&[] } ) ON COLUMNS
FROM ( SELECT ( { [Affiliations].[Affiliation Par].&[True] } ) ON COLUMNS
FROM ( SELECT ( { [Affiliations].[Affiliation Incomplete].&[False] } ) ON COLUMNS
FROM ( SELECT ( { [Affiliations].[Affiliation Active].&[True] } ) ON COLUMNS
FROM [FusionCore]))))))
WHERE ( [Affiliations].[Affiliation Active].&[True],
[Affiliations].[Affiliation Incomplete].&[False],
[Affiliations].[Affiliation Par].&[True],
[Associations].[Record Type].&[Practitioner],
IIF( STRTOSET("[All]", CONSTRAINED).Count = 1, STRTOSET("[All]", CONSTRAINED), [Associations].[Corporate Plan].currentmember ) )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
I have been trying to add a filter funtion or date range in subselect, but not able to achieve or get what i want.
How can I add a line to handle a date range from today through 30 days from now forward?
Solved! Go to Solution.
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...
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...
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |