Forum Discussion

kalpesh07's avatar
kalpesh07
Frequent Visitor
1 year ago
Solved

Cubeset with multiple Period range?

Hey All! need help with creating a Cubeset formula! I've market data at region level for multiple period & brand! I want to know the rank of particular Brand in each region on Specific Period. Formul...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    kalpesh07 , Try using

    =CUBESET(
    "ThisWorkbookDataModel",
    "EXISTS([Brandmaster].[Brand].children,
    ([State_Master].[State].[Maharashtra],
    {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))",
    "Set",
    2,
    "AGGREGATE({([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]})}, SUM)"
    )

kalpesh07's avatar
kalpesh07
Frequent Visitor
1 year ago

Getting #N/A error. It is working fine till part one of the formula but after using Aggregate it is showing the error.

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi kalpesh07 ,

In this forum you will find people who are good at Fabric and Power BI if you believe your query can be resolved by people who are good at Excel and who have experience using powerquery within Excel, you can utilize Excel community: Welcome to the Excel Community | Microsoft Community Hub 


Thanks and Regards