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
- Date slicers require a calendar table that includes all date ranges within your dataset whether the transaction exists or not so if you are planning to analyze a dataset ranging from 01/01/2019 to 12/31/2019, 01/01/2020 to 12/31/2020
then you need to create a calendar table that encompasses those date ranges, therefore you would need a calendar table ranging from 01/01/2019 to 12/31/2020
https://youtu.be/e-CFYi52gpc?t=16
