Forum Discussion

bjackson2760's avatar
bjackson2760
Icon for Helper I rankHelper I
1 year ago
Solved

Sum dynamic parameter fields multiple selected parameter

Here is my scenario: I have 2 parameters with the same amount of colums and I need to be able to select from each of the 2 parameters one or more fields that will sum depending on what fields are se...
Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi bjackson2760 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    I have created sample data . Please refer below snap.

     

     

    Please refer below output snap and attached PBIX file.

     

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi bjackson2760 ,

Thank you for reaching out to the Microsoft Community Forum.

 

I have created sample data . Please refer below snap.

 

 

Please refer below output snap and attached PBIX file.

 

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

  • bjackson2760's avatar
    bjackson2760
    Icon for Helper I rankHelper I
    1 year ago

    Thanks I understand the logic, so no need for anymore assistance!

  • bjackson2760's avatar
    bjackson2760
    Icon for Helper I rankHelper I
    1 year ago

    Thank you so much, I am working on it now...I will get back to you!

  • bjackson2760's avatar
    bjackson2760
    Icon for Helper I rankHelper I
    1 year ago

    Hi Dinesh,

     

    Thank you so much again for providing this.  It has truly been a learning experience.  I have one question regarding your code.  Everything looks great however; I have like what will be 12( a years reports, which whole the columns Jan-Dec Numbers) of these Montly reports at which either of the columns would need to be able to be compared from one monthly finance report to another.  So with regards to the code; how do I add the rest of the files to the following code that you provided to regarding the Month Selector?  I will be renaming it to what you have as I consolidate all the files and rename it to "Fiance_2025".  But, I just wanted to get and understand what January's report would look like.  So how do I continue the code to include Feb_2025, March_2025 and the rest?

    Month Selector =
    ADDCOLUMNS(
        SUMMARIZE(
            Jan_2025,
            'Jan_2025'[Month]
        ),
        "Date",
            DATE(
                2025,  
                SWITCH(
                    TRUE(),
                    'Jan_2025'[Month]="Jan", 1,
                    'Jan_2025'[Month]= "Feb", 2,
                    'Jan_2025'[Month]="Mar", 3,
                    'Jan_2025'[Month]= "Apr", 4,
                    'Jan_2025'[Month]= "May", 5,
                    'Jan_2025'[Month]= "Jun", 6,
                    'Jan_2025'[Month]= "Jul", 7,
                    'Jan_2025'[Month]="Aug", 8,
                    'Jan_2025'[Month]= "Sep", 9,
                    'Jan_2025'[Month]= "Oct",10,
                    'Jan_2025'[Month]= "Nov",11,
                    'Jan_2025'[Month]="Dec",12
                ),
                1
            ),
        "Month Selector", 'Jan_2025'[Month]
    )
     
    Thanks in advance!