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)"
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
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