Forum Discussion
CUBE SET EXPRESSION
Hi Anonymous - I moved this to the DAX area, from Power Query, though this really isn't DAX, but Excel. Power BI has no "Cubeset()" function. Someone here might be able to answer, but you may also get more traction in the Excel forums here.
I have solved it!!!!
=CUBESET("Power BI - SALES"," ([CUSTOMER].[ID SFC Account].&[001b000000UUchgAAD],[Calendar].[FiscalYear].&[2021]) *[ORDERS].[ID SFC order].children","OrderIDS")The filters need to be in brackets separated by a comma - makes sense.
thank you - yes I was coming at this from the point of examining how I can get more out of my PBI datasets. I have also posted it on Mr excel https://www.mrexcel.com/board/threads/cube-set-expression.1147602/
Community ChampionGreat Anonymous - Mr Excel forums are also great for this kind of thing.
I have solved it!!!!
=CUBESET("Power BI - SALES"," ([CUSTOMER].[ID SFC Account].&[001b000000UUchgAAD],[Calendar].[FiscalYear].&[2021]) *[ORDERS].[ID SFC order].children","OrderIDS")The filters need to be in brackets separated by a comma - makes sense.