Forum Discussion
Cubeset Formula Help Needed
Greetings-Giving this a shot in the forum but feel free to direct me to a more specific area if needed.
I have a working Cubeset/Cuberankedmember combination working and I'm trying to solve for how to include a slicer name in the Cubeset formula (if possible) so my users can dynamically change the date for the data.
Here's the Cubeset that finds my wine categories:
CUBESET("ThisWorkbookDataModel","([Ecommerce Data].[Major Category].[All].[Wine],[Ecommerce Data].[Category].Children)","Wine Category",2,"[Measures].[Ttl $ TY]")
Is there a way to incorporate a date slicer (like Slicer_Month that I have in my data) into the set expression of the Cubeset?
I haven't found a way that works or any information on line to solve. I thought I could do something like "([Ecommerce Data].[Major Category].[All].[Wine],[Ecommerce Data].[Category].Children),Slicer_Month" but nothing I've tried works.
thank you for any help!
2 Replies
- SPRexIron ContributorPlease can we have ability for customisations?
Like some extra custom fields that can be buttons or number or text or choice or calculated(formula) fields...- LeonPavesicSilver Contributor
Hi SPRex,
this is a good idea but unfortunately, this feature is not available in Microsoft Planner.
You may want to provide this feedback directly using the Give Feedback in Microsoft Planner or posting directly in Microsoft Feedback Portal (Ideas · Community (microsoft.com))- Salman_AlkweldyCopper Contributor