Cubeset Formula Help Needed

%3CLINGO-SUB%20id%3D%22lingo-sub-2352390%22%20slang%3D%22en-US%22%3ECubeset%20Formula%20Help%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2352390%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings-Giving%20this%20a%20shot%20in%20the%20forum%20but%20feel%20free%20to%20direct%20me%20to%20a%20more%20specific%20area%20if%20needed.%3C%2FP%3E%3CP%3EI%20have%20a%20working%20Cubeset%2FCuberankedmember%20combination%20working%20and%20I'm%20trying%20to%20solve%20for%20how%20to%20include%20a%20slicer%20name%20in%20the%20Cubeset%20formula%20(if%20possible)%20so%20my%20users%20can%20dynamically%20change%20the%20date%20for%20the%20data.%3CBR%20%2F%3E%3CBR%20%2F%3EHere's%20the%20Cubeset%20that%20finds%20my%20wine%20categories%3A%3CBR%20%2F%3ECUBESET(%22ThisWorkbookDataModel%22%2C%22(%5BEcommerce%20Data%5D.%5BMajor%20Category%5D.%5BAll%5D.%5BWine%5D%2C%5BEcommerce%20Data%5D.%5BCategory%5D.Children)%22%2C%22Wine%20Category%22%2C2%2C%22%5BMeasures%5D.%5BTtl%20%24%20TY%5D%22)%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20to%20incorporate%20a%20date%20slicer%20(like%20Slicer_Month%20that%20I%20have%20in%20my%20data)%20into%20the%20set%20expression%20of%20the%20Cubeset%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20haven't%20found%20a%20way%20that%20works%20or%20any%20information%20on%20line%20to%20solve.%20I%20thought%20I%20could%20do%20something%20like%20%22(%5BEcommerce%20Data%5D.%5BMajor%20Category%5D.%5BAll%5D.%5BWine%5D%2C%5BEcommerce%20Data%5D.%5BCategory%5D.Children)%2CSlicer_Month%22%20but%20nothing%20I've%20tried%20works.%3CBR%20%2F%3E%3CBR%20%2F%3Ethank%20you%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2352390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2353356%22%20slang%3D%22en-US%22%3ERe%3A%20Cubeset%20Formula%20Help%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2353356%22%20slang%3D%22en-US%22%3EDate%20slicers%20require%20a%20calendar%20table%20that%20includes%20all%20date%20ranges%20within%20your%20dataset%20whether%20the%20transaction%20exists%20or%20not%20so%20if%20you%20are%20planning%20to%20analyze%20a%20dataset%20ranging%20from%2001%2F01%2F2019%20to%2012%2F31%2F2019%2C%2001%2F01%2F2020%20to%2012%2F31%2F2020%3CBR%20%2F%3Ethen%20you%20need%20to%20create%20a%20calendar%20table%20that%20encompasses%20those%20date%20ranges%2C%20therefore%20you%20would%20need%20a%20calendar%20table%20ranging%20from%2001%2F01%2F2019%20to%2012%2F31%2F2020%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fe-CFYi52gpc%3Ft%3D16%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2Fe-CFYi52gpc%3Ft%3D16%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2353396%22%20slang%3D%22en-US%22%3ERe%3A%20Cubeset%20Formula%20Help%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2353396%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20but%20I%20have%20all%20this.%26nbsp%3B%20I'm%20way%20past%20that%20and%20am%20trying%20to%20use%20the%20Slicer%20name%20in%20a%20Cubeset%20to%20mine%20the%20data%20for%20a%20standalone%20(not%20a%20pivot)%20table.%26nbsp%3B%20I%20welcome%20any%20additional%20thoughts.%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047584%22%20target%3D%22_blank%22%3E%40Yea_So%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

Thanks but I have all this.  I'm way past that and am trying to use the Slicer name in a Cubeset to mine the data for a standalone (not a pivot) table.  I welcome any additional thoughts.  @Yea_So